"""
# 切换到postgres用户
su - postgres

# 进入posql交互
psql
# 创建用户
CREATE USER 用户名 PASSWORD '密码';

# 授权所有权限
ALTER USER 用户名 WITH SUPERUSER CREATEDB;
ALTER USER wjcroom WITH SUPERUSER CREATEDB;
ALTER USER wjcroom WITH CREATEDB;
ALTER USER wjcroom WITH CREATEROLE;
ALTER USER wjcroom WITH REPLICATION;

sudo su -l postgres -c "exec /usr/bin/pg_ctl restart"
"""
import psycopg2
dsn=f"dbname='exp_db' user='wjcroom' host='192.168.1.11' password='11111311'"
conn=psycopg2.connect(dsn)
cur = conn.cursor()
cur.execute("select * from table_one;")
print(cur.fetchone())
#('John',)
conn.close