1、使用psycopg2连接postgresql，首先需要安装python psycopg2依赖包
pip install psycopg2
2、数据库连接
import psycopg2
try:
conn = psycopg2.connect(database="tables", user="postgres", password="***", host="127.0.0.1", port="5432")
cur = conn.cursor()
# 执行sql语句 查询
cur.execute("SELECT name, years from students")
# 获取所有
rows = cur.fetchall() #返回list
# 获取一条
rows = cur.fetchone() #返回无组
except Exception as e:
print(‘error,%s‘ % e)
finally:
cur.close()
conn .close()
3、如果修改了数据库就要都写 conn.commit()
4、execute可以执行增删改的SQL，执行带参数的SQL
sql = "INSERT INTO USER1(name, age) VALUES (%s, %s);"
username = "Alex"
age = 18
cursor.execute(sql, [username, age])
5、查询结果为list
原文：https://www.cnblogs.com/testlife2020/p/12980453.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群