The PostgreSQL ODBC driver (officially called psqlODBC ) allows applications like Microsoft Excel, Power BI, Tableau, LibreOffice, and custom software to connect to a PostgreSQL database using the industry-standard ODBC API.
[PostgreSQL] Description = PostgreSQL ODBC driver Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libpsqlodbcw.so FileUsage = 1 Then create a Data Source Name (DSN) in /etc/odbc.ini or ~/.odbc.ini : install postgresql odbc driver
[mydatabase] Driver = PostgreSQL Server = localhost Port = 5432 Database = mydb Username = myuser Password = mypass Test the connection: The PostgreSQL ODBC driver (officially called psqlODBC )