Postgres Odbc Driver [new] <2025>

Connecting is easy, but getting it to perform well requires a few tweaks in the DSN configuration:

| PostgreSQL Type | ODBC SQL Type | C Type | |----------------|---------------|--------| | int4 | SQL_INTEGER | SQL_C_LONG | | int8 | SQL_BIGINT | SQL_C_SBIGINT | | float8 | SQL_DOUBLE | SQL_C_DOUBLE | | text / varchar | SQL_VARCHAR | SQL_C_CHAR | | timestamp | SQL_TIMESTAMP | SQL_C_TIMESTAMP | | boolean | SQL_BIT | SQL_C_BIT | | bytea | SQL_LONGVARBINARY | SQL_C_BINARY | | json / jsonb | SQL_VARCHAR | SQL_C_CHAR | | uuid | SQL_GUID | SQL_C_GUID |

psqlODBC is released under the version 2.1 or later, making it suitable for both open-source and proprietary applications.

You will likely need to edit the odbcinst.ini (driver definition) and odbc.ini (DSN definition) files manually in /etc/ .

Here is what you need to know to get it running and optimized.