python测试postgres远程登录

#首先安装psycopg2模块，如果是高版本的python可以使用psycopg2-binary已编译版本模块，语法不变

import psycopg2

 

# 配置数据库连接参数

conn_params = {

"dbname": "your_db",

"user": "your_user",

"password": "your_password",

"host": "your_host",

"port": "5432"

}

 

# 尝试连接数据库

try:

conn = psycopg2.connect(**conn_params)

print("连接成功")

 

# 创建一个游标对象

cur = conn.cursor()

 

# 编写SQL查询

cur.execute("SELECT version();")

 

# 获取查询结果

db_version = cur.fetchone()

 

print(db_version)

 

# 关闭游标

cur.close()

 

# 关闭连接

conn.close()

 

except psycopg2.Error as e:

print("数据库连接失败:", e)