查看用户信息:
select * from pg_user;
设置用户有效期,例如设置到2024-03-01:
alter user user_name with valid until '2024-03-01 08:00:00';
如果要设置永久有效,可以用
alter user user_name with valid until 'infinity';
修改用户密码:
ALTER USER user_name WITH PASSWORD 'xxx';