In most cases, you will need to have an ODBC Connection for PostgreSQL. If you are working with GIS software, mostly you will need to have a ODBC Connection. In this article, I am going to guide you how to create a PostgreSQL ODBC connection in Windows 10. ODBC Connection is a bridge between the database server and your application.
In order to create a PostgreSQL ODBC Connection, please follow these steps below.
- Download and Install PostgreSQL ODBC
- Create and connect your PostgreSQL Server
Step 1. Download and Install PostgreSQL ODBC
Please download the psqlodbc installation file from this link. This is the official release of the PostgreSQL ODBC installer for Windows 10.
Step 2. Create and Connect to PostgreSQL Server
After we install the driver on step 1, now open Control Panel | Administrative Tools | ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). Please note that if you are going to connect to this ODBC from a
There are several ways to create the DSN (Data Source Name). You may notice that there are several DSN tabs on the ODBC Data Source Administrator window above. The User DSN will only visible to You (current user) and can only be used on your current computer. The System DSN is visible to all users on your computer. The File DSN can be shared with other users across computers who has the same driver.
Click Add and then select the PostgreSQL ANSI or Unicode. If you don’t see the PostgreSQL driver in the list, you may need to re install the PostgreSQL Driver in Step 1.
Click Finish and then enter your PostgreSQL Server and database credentials.
Click Test to make sure the connection is working properly. Hit Save to save the connection.