python连接pgsql数据库

python连接pgsql数据库

# 导入psycopg2包
import psycopg2
# 配置项
database = ""
user = ""
password=""
host=""
port=""

# 连接到数据库
conn = psycopg2.connect(database=database, user=user,password=password, host=host, port=port)

# 建立游标，用来执行数据库操作
cursor = conn.cursor()

# 执行SQL命令
cursor.execute("CREATE TABLE test_conn(id int, name text)")
cursor.execute("INSERT INTO test_conn values(1,'haha')")

# 提交SQL命令
conn.commit()

# 执行SQL SELECT命令
command = 'SELECT * FROM test_conn ' 
cursor.execute(command)

## 获取SELECT返回的元组
rows = cursor.fetchall()