psycopg2-example.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import psycopg2
import sys

con = None

conn_string = "host='localhost' dbname='mydb' user='myuser' password='mypass'"

try:
    con = psycopg2.connect(conn_string)
    cur = con.cursor()
    #cur.execute('SELECT version()')
    #ver = cur.fetchone()
    #print ver
    cur.execute('SELECT id, name from address order by name')
    rows = cur.fetchall()
    for row in rows:
        print row[0], " ", row[1]

except psycopg2.DatabaseError, e:
    print 'Error %s' % e
    sys.exit(1)

finally:
    if con:
        con.close()