ALTER USER

ALTER USER changes a database user account

Syntax

ALTER USER name [ WITH [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' ]

Semantics

name	specifies the name of the user to alter; names that contain special characters must be double-quoted.
ENCRYPTED	is the default.
password	is the password to assign to the user.

Notes

User names are not case-sensitive.
ALTER USER ... PASSWORD cannot be used in a database that was created without a superuser password.
ERROR: authorization method for database name is TRUST; no password set