一、环境准备
win10安装PostgreSQL12.6：https://cloud.tencent.com/developer/article/1929286
Linux在线安装部署postgresql12 postgis3.1： https://cloud.tencent.com/developer/article/1818708
二、连接代码
代码语言：javascript复制#-*- encoding: utf-8 -*-
import psycopg2
# 数据库连接参数
## dbname: the database name
## database: the database name (only as keyword argument)
## user: user name used to authenticate
## password: password used to authenticate
## host: database host address (defaults to UNIX socket if not provided)
## port: connection port number (defaults to 5432 if not provided)
conn = psycopg2.connect(database="xl",
user="xl", password="123456",
host="127.0.0.1", port="5432")
cur = conn.cursor()
cur.execute("SELECT * FROM t_user;")
rows = cur.fetchall() # all rows in table
print(rows)
conn.commit()
cur.close()
conn.close()
