Re: Changing user passwords - Mailing list pgsql-sql

> Is it possible to change a user's password without using the pg_passwd
> command?
> For example, how does a user changes his password from the interactive
> monitor?

See the following commands:

CREATE USER
ALTER USER
CREATE GROUP
ALTER GROUP

For example:

ALTER USER user1 WITH PASSWORD 'password1';

Please note thatuser passwords cannot be changed in a transaction. ( 7.0.2
)
Laci 1.0