查看 pgsql 用户列表:
select rolname from pg_roles;创建用户
CREATE USER shmaur WITH PASSWORD 'password';删除用户
DROP USER IF EXISTS myuser;列出所有用户
\du修改用户成管理员
ALTER ROLE shmaurPost SUPERUSER;修改用户密码
ALTER USER postgre WITH PASSWORD 'xxxpassword';
查看 pgsql 用户列表:
select rolname from pg_roles;创建用户
CREATE USER shmaur WITH PASSWORD 'password';删除用户
DROP USER IF EXISTS myuser;列出所有用户
\du修改用户成管理员
ALTER ROLE shmaurPost SUPERUSER;修改用户密码
ALTER USER postgre WITH PASSWORD 'xxxpassword';
“您的支持是我持续分享的动力”
文章类别