python操作postgres数据库

需要引入一个模块psycopg2，

完成postgresql数据库的增删改查操作。

import psycopg2
#import json

pgconn = psycopg2.connect(host = "111.111.123.123", database = "bj_scene", user = "map", password = "", port="8432")
pgcur = pgconn.cursor()

sql = "delete from t_se;"
pgcur.execute(sql)

str_se_id = "12123"
str_status = "1"
sql = "insert into t_se (se_id,status) values ('123','0'),('%s','%s')" %(str_se_id,str_status)
pgcur.execute(sql)

sql = "update t_se set memo = 'iamqq' where se_id = '%s'" % str_se_id
pgcur.execute(sql)

sql = "select * from t_se"
pgcur.execute(sql)
retdata = pgcur.fetchall() 
print retdata

pgconn.commit()

pgcur.close()

pgconn.close()