# 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:
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:
[mydatabase] Driver = PostgreSQL Server = localhost Port = 5432 Database = mydb Username = myuser Password = mypass Test the connection:
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.
