PostgreSQL | psycopg2语句汇总

import psycopg2
import psycopg2.extras
 
conn = psycopg2.connect(host=‘localhost‘,port=5432,user=‘POSTGRes‘,password=‘POSTGRes‘,database=‘test‘)  
#输入相关数据库配置
 
cursor = conn.cursor(cursor_factory=psycopg2.extras.Dictcursor)  
#这里创建的是一个字典cursor,这样返回的数据,都是字典的形式,方便使用

cursor.execute(‘SELECT * FROM test WHERE ID > %s;‘,(5,))

cursor.mogrify(‘SELECT * FROM test WHERE a = %s AND b = %s;‘,(‘a‘,‘b‘))

cursor.query