psqlODBC

psqlODBC is a PostgreSQL ODBC driver that can be used with the integrated connection administrator that is database- and OS-independent in order to access the PostgreSQL DBMS (which is the PostgreSQL database management system).

This software solution can help advanced computer users set up connections that can be used by every single application in their system via the native ODBC Data Source Administrator. Once the connection has been successfully configured, it will help them work with pieces of data stored within the PostgreSQL server both quickly and directly.

Deploying the driver on the target system can be done by choosing the architecture type from the download section and retrieving the appropriate document, depending on the workplace environment, unpacking the archive and running the installer that's bundled within it.

Standard: Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase; Uid=myUsername;Pwd=myPassword;

ANSI: Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase; Uid=myUsername;Pwd=myPassword;

Unicode: Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=myDataBase; Uid=myUsername;Pwd=myPassword;

SSL: Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase; Uid=myUsername;Pwd=myPassword;sslmode=require;