数据库管理postgresql 查询数据 python

By geo
python postgresql 
CREATE DATABASE testdb;

import psycopg2

conn = psycopg2.connect(
    dbname="demodb",
    user="postgres",
    password="123",
    host="localhost",
    port="5432"
)

cur = conn.cursor()

设定数据库

cur.execute("SELECT version();")
print(cur.fetchone())
cur.close()
conn.close()

查询数据库版本