: Select "PostgreSQL Unicode" or "PostgreSQL ANSI," then enter your server details (Host, Port, Database, User, Password).
This file registers the driver.
| PostgreSQL Type | ODBC SQL Type | Notes | |----------------|---------------|-------| | integer | SQL_INTEGER | | | bigint | SQL_BIGINT | | | text , varchar | SQL_VARCHAR (Unicode) | | | numeric | SQL_NUMERIC | Precision preserved | | boolean | SQL_BIT or SQL_VARCHAR | Configurable via BoolsAsChar | | timestamp | SQL_TYPE_TIMESTAMP | Microsecond precision | | json , jsonb | SQL_LONGVARCHAR | Retrieved as text | | uuid | SQL_GUID (or SQL_CHAR ) | Native support in v12+ | | bytea | SQL_LONGVARBINARY | | | array | SQL_VARCHAR (stringified) | Use array_to_string() in query | postgresql driver odbc
The official driver for PostgreSQL is called . It is open-source, maintained by the PostgreSQL community, and is the standard choice for connecting to PostgreSQL from Windows, Linux, and macOS. : Select "PostgreSQL Unicode" or "PostgreSQL ANSI," then