Re: create user xxx with md5 string? - Mailing list pgsql-sql

Hello all.

Tom right. Encrypted MD5 passwords computed as md5(password || test10). I checked.

Regards, Dmitriy Igrishin. 

2009/12/3 Tom Lane <tgl@sss.pgh.pa.us>

Gerardo Herzig <gherzig@fmed.uba.ar> writes:
> Hi all. Im triyng, with no success, to create a user, and set the
> password with a md5 string.

The correct method for computing the md5'd password includes the
username.  I think it's 'md5' || md5sum(password || username)
but look at the code or docs.

                       regards, tom lane

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql