import psycopg2
#连接数据库
conn = psycopg2.connect(database=“postgres”, user=“postgres”,
password=“postgres”, host=“202.202.66.169”, port=“32786”)
#创建游标
cursor = conn.cursor()
#执行mysql语句
cursor.execute(“select * from diagnosis_traindata”)
#提交命令
conn.commit()
#获取SELECT返回的元组
rows = cursor.fetchall()
cursor.close()
conn.close()
print(rows)