1、安装
# windows下:
pip install psycopg2
# linux下:
# 1、存在psycopg2
pip install psycopg2
# 2、不存在psycopg2
pip install psycopg2-binary
2、数据库操作
# 2.1 数据库连接
import psycopg2
conn = psycopg2.connect(database="yourDB", user="yourUser", password="yourPasswprd", host="127.0.0.1", port="5432")
# 2.2 insert
import psycopg2
conn = psycopg2.connect(database="yourDB", user="yourUser", password="yourPasswprd", host="127.0.0.1", port="5432")
cur = conn.cursor()
# 组装sql语句
cur.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
VALUES (1, 'Paul', 32, 'California', 20000.00 )")
# 真正执行数据库写入 | 前面可以组装多个sql语句,然后一次性写入数据库
conn.commit()
print("Records created successfully")
conn.close()
更多操作查看Erick-LONG的python 操作PostgreSQL。