# Register the driver (if not auto-registered) 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 :

Install Postgresql Odbc Driver -

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

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