isql mydatabase myuser mypass -v Using Homebrew (Recommended) brew update brew install unixodbc brew install psqlodbc Manual linking (if needed) # psqlODBC files are usually installed in /usr/local/lib/psqlodbc/ # Register the driver sudo nano /etc/odbcinst.ini Add:

[mydatabase] Driver = PostgreSQL Server = localhost Port = 5432 Database = mydb Username = myuser Password = mypass Test the connection:

[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 :

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.

# Register the driver (if not auto-registered) sudo nano /etc/odbcinst.ini Add: