开始增删改查
2018-11-06 本文已影响9人
哆啦在这A梦在哪
import psycopg2
con = psycopg2.connect(database="kcgl",user="postgres",password="123456",host="localhost",port="5432")
db = con.cursor()
db.execute("insert into role values (%s,%s,%s)",('test','r',1))
db.execute("delete from role where name='test'")
db.execute("update role set visible=1 where name='test'")
con.commit()
con.close()
db.close()
