postgresql 数据库查询

#!/usr/local/bin/python

import psycopg2

conn = psycopg2.connect(database = "policy_pro", user = "policy_opr", password = "eWEeFZTGS5PkviKW", host = "10.200.18.1", port="3433")
print "Open database success"

cur = conn.cursor()
psql0 = "select template_id from signcreat.t_sign_template t where  template_signature_type='01' and template_id > 1386 order by template_id"
cur.execute(psql0)
psqla = cur.fetchall()
# print psqla

i=0
j=56360526
for a in psqla:
    psql = " select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = %s ; "  % a[0]
    cur.execute(psql)
    rows = cur.fetchone()
    j = j + rows[0]
    print a[0], rows[0], j
    i = i+1
print 'end'

# import os
# import time
#
# psql = ''' psql  -h 10.200.18.1 -p 3433 -U policy_opr -d policy_pro  -c "  select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = 128 and is_del = '1' " '''
# a= os.popen(psql,'r')
# print a.read()