Postgres: Change User Password

查看角色权限

postgres-# \du

Role name  |                         Attributes                         | Member of
------------+------------------------------------------------------------+-----------
postgres   | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

更改用户密码

ALTER USER postgres WITH ENCRYPTED PASSWORD 'password';