The CData ODBC Driver for PostgreSQL is a standards-based ODBC driver with editions for Windows and Unix-based operating systems, like macOS and Linux. The following sections show how to create an ODBC data source and query data.

Creating a DSN on Your Platform

The following guides show how to use the standard tools to configure data source names (DSN).

• Windows

  Windows DSN Configuration shows how to configure a DSN with the Microsoft ODBC Administrator tool.

• macOS

  macOS DSN Configuration shows how to configure a DSN with the iODBC driver manager.

• Linux

  Linux DSN Configuration shows how to configure DSNs with several major driver managers on Linux.

PostgreSQL Version Support

The driver enables standards-based access to PostgreSQL databases version 7.4 and later.

See Also

See the following sections to connect to the DSN from tools and from code:

• Using from Tools: Connect to the DSN from various tools on different platforms.
• Using ODBC: Connect to the DSN using the native ODBC API.
• Create a Linked Server: Connect to the DSN as a remote SQL Server database.
• MySQL Remoting: Connect to the DSN over the MySQL protocol.