Postgres SQL: User management

alter user POSTGRES with password 'newPassword';