psycopg2参数化查询

#!/usr/bin/env python
#--- coding: utf8 ---


import psycopg2 as p2


conn = p2.connect(user='nsc', password='xxxxx', host='10.67.1.176', port=5432)
csor = conn.cursor()


#非参数化查询
#csor.execute("select * from pg_tables where schemaname='internal_app_bsaata' and tablename='event_ip_real'")
#list参数化查询
#sql = "select * from pg_tables where schemaname=%s and tablename=%s"
#csor.execute(sql, ['internal_app_bsaata', 'event_ip_real'])
#dict参数化查询
sql = "select * from pg_tables where schemaname=%(db_name)s and tablename=%(tb_name)s"
csor.execute(sql, {'db_name':'internal_app_bsaata', 'tb_name':'event_ip_real'})


rst = csor.fetchall()
print rst