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: install postgresql odbc driver
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. install postgresql odbc driver