"Vladimir V. Zolotych" wrote:
>How can I set password on existing database ?
template1=# \help alter user
Command: ALTER USER
Description: Modifies user account information
Syntax:
ALTER USER username
[ WITH PASSWORD 'password' ]
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
[ VALID UNTIL 'abstime' ]
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"All that the Father giveth me shall come to me; and
him that cometh to me I will in no wise cast out."
John 6:37