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';