Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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()
Add Comment
Please, Sign In to add comment