python postgresql跨数据库操作_python 操作postgres数据库

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