DB Wiki

psycopg Homepage
psycopg2 Installation

import psycopg2
import psycopg2.extras
 
conn = psycopg2.connect(database="doob", user = "ian", password = "pwd", host = "localhost")
print "Connection Successful"
 
#cur = conn.cursor()
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
 
query = "SELECT usename, usesuper FROM pg_user"
cur.execute(query)
 
rows = cur.fetchall()
 
for row in rows:
  print(row)
  print(f"{row['usename']} {row['usesuper']}")
 
cur.close()