[PostgreSQL] Description = PostgreSQL ODBC driver Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so Setup = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Driver64 = /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so Setup64 = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so FileUsage = 1 Then create a DSN in /etc/odbc.ini :
Introduction Open Database Connectivity (ODBC) is a critical middleware API that allows applications like Microsoft Excel, Tableau, Power BI, and custom software to communicate with databases. If you need to connect a Windows, Linux, or macOS application to a PostgreSQL database, the PostgreSQL ODBC driver (also known as psqlODBC ) is the essential bridge.
https://www.postgresql.org/docs/current/odbc.html Last updated: Q2 2025. Always check for newer stable releases at the official PostgreSQL archive.
sudo apt update sudo apt install odbc-postgresql