#!/usr/bin/python
#
#
#
import psycopg2

def connect(dbase, usr, pwd):
	try:
		conn = psycopg2.connect("dbname={} user={} host=localhost password={}".format(dbase,usr,pwd))
		return conn
	except:
		print "Cant connect"

def query(conn):
	if conn:
		conn.cursor()
		try:
			conn.execute("""select * from mytable limit 10""")
			rows = conn.fetchall()
			for row in rows:
				print "	",row[0],row[1]
		except:
			print "Error fetching data\n"

conn = connect("database","user","pass")
q = query(conn)


#> python test.py
Error fetching data
#>