Fajar Priyanto wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dear all,
> I'm completely new with postgres. I want to change the password of the
> psql root, but I can't find any command for it. I've searched the FAQ,
> Admin Guide, and also the mailing list, but it seems that they all assume
> that we're already know to do it.
> Is there any equivalent command like in mysql's: mysqladmin -u root
> password password?
> Thanks
from psql:
bnl=# \h alter user
Command: ALTER USER
Description: change a database user account
Syntax:
ALTER USER username [ [ WITH ] option [ ... ] ]
where option can be:
[ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| VALID UNTIL 'abstime'
ALTER USER username SET variable { TO | = } { value | DEFAULT }
ALTER USER username RESET variable
/Björn
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
