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