Postgresql Odbc Windows Updated Jun 2026

PostgreSQL ODBC Windows: A Detailed Guide This guide provides step-by-step instructions for installing and configuring the PostgreSQL ODBC driver on Windows. Prerequisites

PostgreSQL server (version 9.4 or later) installed on a remote machine or locally Windows 7, 8, 10, or 11 Administrative privileges

Step 1: Download and Install the PostgreSQL ODBC Driver

Go to the PostgreSQL ODBC driver download page and select the correct version for your Windows architecture (32-bit or 64-bit). Click on the download link to download the installer (e.g., psqlodbc_12_00_0000.zip ). Extract the contents of the zip file to a directory on your system (e.g., C:\temp\psqlodbc ). Run the installer (e.g., psqlodbc-setup.exe ) and follow the prompts to install the driver. postgresql odbc windows

Step 2: Configure the PostgreSQL ODBC Driver

Open the ODBC Data Sources Administrator (you can search for it in the Start menu or type odbcadmn in the Run dialog box). Click on the System DSN tab and then click Add . Select PostgreSQL ODBC Driver from the list of available drivers and click Finish . In the PostgreSQL ODBC Driver Setup dialog box, enter the following information:

Data Source Name : a name for your data source (e.g., my_postgres_db ). Host : the hostname or IP address of your PostgreSQL server (e.g., localhost or 192.168.1.100 ). Port : the port number used by your PostgreSQL server (default is 5432 ). Database : the name of the database you want to connect to (e.g., mydatabase ). User : the username to use for the connection (e.g., myuser ). Password : the password to use for the connection (e.g., mypassword ). PostgreSQL ODBC Windows: A Detailed Guide This guide

Click OK to save the configuration.

Step 3: Test the Connection

In the ODBC Data Sources Administrator , select the data source you created in Step 2 and click Configure . Click Test to test the connection. If the connection is successful, you should see a message indicating that the connection was successful. Extract the contents of the zip file to

Step 4: Use the PostgreSQL ODBC Driver in Your Application

In your application, create a new ODBC connection using the data source name you created in Step 2. Use the ODBC connection to execute SQL queries against your PostgreSQL database.