Changes an existing user's password:
ALTER USER userName WITH PASSWORD 'newPassword';
userName- existing user's name.
newPassword- a new password to set for the user's account.
The command changes an existing user's password.
The password can be updated by the superuser (ignite, see for more details) or by the user himself.
Updating user's password:
ALTER USER test WITH PASSWORD 'test123';
Updated less than a minute ago