Roles (users) :: PostgreSQL
Alter role password
Assume the role devel has admin privileges. |
$ docker compose exec db psql -U devel -d devel -W
devel#=> SELECT * FROM pg_roles WHERE rolname like '%blog%';
rolname
---------
blog1
devel#=> ALTER USER blog1 WITH LOGIN PASSWORD 's3cr37';