from db import conn, curs
from pprint import pprint


curs.execute("""SELECT table_name FROM information_schema.tables
             WHERE table_schema='public' AND table_type='BASE TABLE'""")
tables = (x[0] for x in curs.fetchall())

for tbl in tables:
    print tbl.capitalize()
    print "="*len(tbl)
    curs.execute("""SELECT column_name, data_type, character_maximum_length,
                 numeric_precision, numeric_precision_radix, numeric_scale, is_nullable
                 FROM information_schema.columns
                 WHERE table_name=%s
                 ORDER BY ordinal_position""", (tbl, ))
    pprint(curs.fetchall())