DB Wiki

psycopg Homepage
psycopg2 Installation

import psycopg2
 
conn = psycopg2.connect(database="doob", user = "ian", password = "pwd", host = "localhost")
print "Connection Successful"
 
cur = conn.cursor()
cur.execute('''select usename, usesuper from pg_user;''')
 
for row in cur:
  print(row)
 
cur.close()