Datbase Example: PostgreSQL

import pg    # PostgreSQL database module
from pprint import pprint  # pretty printing

QUERY="""SELECT customer_name, balance
   FROM account, depositor
   WHERE account.balance > 500
        and account.account_number=depositer.account_number"""

db = pg.connect(dbname='bank', host='localhost', user='zelle')
res = db.query(QUERY)
print res.ntuples()
pprint(res.getresult())
pprint(res.dictresult())
pprint(res.listfields())

----------------------------------------------------------------

4
[('Johnson', 900.0), ('Jones', 750.0), ('Lindsay', 700.0)]
[{'customer_name': 'Johnson', 'balance': 900.0},
 {'customer_name': 'Jones', 'balance': 750.0},
 {'customer_name': 'Lindsay', 'balance': 700.0}]
('customer_name', 'balance')