conn = pyodbc.connect( 'DSN=PSQL_SalesDB;UID=user;PWD=pass' ) cursor = conn.cursor() cursor.execute("SELECT * FROM Customers WHERE State = 'TX'") for row in cursor.fetchall(): print(row) conn.close()
The PostgreSQL ODBC driver (psqlODBC) is the essential bridge connecting Windows and Linux applications to PostgreSQL databases. Whether you are using Excel to analyze data, connecting a legacy C++ app, or linking Microsoft Access to a cloud-hosted Postgres instance, this driver makes it possible. psql odbc driver
If you prefer "DSN-less" connections in your code (Python, C#, PHP), use a connection string format like this: conn = pyodbc
To ensure a stable connection, fill out the following fields in the setup dialog: conn = pyodbc.connect( 'DSN=PSQL_SalesDB