Odbc Postgres Driver: |best|

+---------------------------------------+ | Connected! | | sql-statement | | help [tablename] | | quit | +---------------------------------------+ SQL> | Driver Version | PostgreSQL Versions | ODBC Standard | |----------------|---------------------|---------------| | 9.x | 8.4 - 11 | 3.5 | | 10.x | 9.x - 13 | 3.5 | | 11.x | 10 - 14 | 3.5 | | 12.x | 11 - 15+ | 3.5 | | 13.x | 12 - 16+ | 3.5 |

conn.Open(); OdbcCommand cmd = new OdbcCommand("SELECT COUNT(*) FROM orders WHERE status = 'pending'", conn); int count = Convert.ToInt32(cmd.ExecuteScalar()); Console.WriteLine($"Pending orders: count"); odbc postgres driver

cursor.execute("SELECT id, name FROM users WHERE active = true") rows = cursor.fetchall() +---------------------------------------+ | Connected