# Ubuntu/Debian sudo apt install odbc-postgresql sudo yum install postgresql-odbc macOS (Homebrew) brew install psqlodbc
Here’s a draft for a blog post about . It’s written for developers and DBAs who need to connect PostgreSQL to BI tools, custom apps, or ETL processes. Everything You Need to Know About PostgreSQL ODBC Drivers If you’ve ever tried to connect a tool like Microsoft Excel, Tableau, Power BI, or an old .NET app to PostgreSQL, you’ve likely run into the need for an ODBC driver . It’s the universal translator that lets applications speak to PostgreSQL using the Open Database Connectivity standard. postgresql odbc drivers
[my_postgres_db] Driver = PostgreSQL Unicode Server = localhost Port = 5432 Database = mydb Username = myuser Password = mypass In a connection string: # Ubuntu/Debian sudo apt install odbc-postgresql sudo yum
Then configure /etc/odbcinst.ini and /etc/odbc.ini (or ~/.odbc.ini for user DSNs). Here’s a sample DSN entry (for odbc.ini ): It’s the universal translator that lets applications speak