DSN=MyPostgresDB;UID=postgres;PWD=secret (no DSN):
import pyodbc conn = pyodbc.connect('DSN=MyPostgresDB') cursor = conn.cursor() cursor.execute("SELECT version();") print(cursor.fetchone()) DSN-based :
DSN=MyPostgresDB;UID=postgres;PWD=secret (no DSN):
import pyodbc conn = pyodbc.connect('DSN=MyPostgresDB') cursor = conn.cursor() cursor.execute("SELECT version();") print(cursor.fetchone()) DSN-based : odbc postgresql