Python3连接PostgreSQL

#-*- 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()