gistfile1.py

# -*- coding: utf-8 -*-

import sys
from psycopg2 import connect
from DBSingleStyle import Param, to_format


if __name__=='__main__':
    query = ('SELECT table_name, column_name, data_type \
FROM information_schema.columns WHERE table_name=', Param(sys.argv[1]))

    conn = connect("dbname='template1' user='postgres' host='localhost'")
    cur = conn.cursor()
    cur.execute(*to_format(query))
    for row in cur.fetchall():
        print row
    conn.close()