Psql Odbc Driver

using (OdbcConnection conn = new OdbcConnection( "DSN=PSQL_SalesDB;Uid=user;Pwd=pass"))

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() psql odbc driver

conn.Open(); OdbcCommand cmd = new OdbcCommand( "UPDATE Orders SET Status='Shipped' WHERE OrderID=1001", conn); cmd.ExecuteNonQuery(); Pwd=pass")) conn = pyodbc.connect( 'DSN=PSQL_SalesDB

While "PSQL" often refers to PostgreSQL in casual contexts, in legacy enterprise systems PSQL specifically means Pervasive PSQL (or Actian Zen). This text focuses on that engine. For PostgreSQL ODBC, see the psqlodbc driver. see the psqlodbc driver.