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

python 操作postgres数据库