Re: password encryption

On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:

> Hello,
>
> I want to encrypt passwords with Postgresql the way mySQL does it with :
>
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Check out the ALTER command.

ALTER USER username
    [ WITH PASSWORD 'password' ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]


Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814