从Psycopg 2.7开始,有安全
sql模块:
from psycopg2 import sqlquery = sql.SQL("alter table t add column {} text")row1 = ('col1', 'col2')for c in row1: cursor.execute(query.format(sql.Identifier(c)))
使用2.6及更早版本:
采用
psycopg2.extensions.AsIs
import psycopg2from psycopg2.extensions import AsIsconn = psycopg2.connect("host=localhost4 port=5432 dbname=cpn")cursor = conn.cursor()query = "alter table t add column %s text"row1 = ('col1', 'col2')for c in row1: cursor.execute(query, (AsIs(c),))conn.commit()
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)