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

Tom Lane wrote:
> 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
> 
Perfect! I could not find that in the docs.
It works. Thanks!

Gerardo