On Tue, Sep 14, 2010 at 9:50 AM, Carlos Mennens
<carlos.mennens@xxxxxxxxx> wrote:
> Secondly I am unable to find any information in the docs that show me
> how to set just the user password for 'carlos'. In MySQL I would use:
>
> SET PASSWORD FOR 'carlos'@'localhost' = PASSWORD('newpass');
You'd want to use "ALTER USER"
http://www.postgresql.org/docs/8.4/interactive/sql-alteruser.html
So:
ALTER USER carlos WITH ENCRYPTED PASSWORD 'password';
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
