Re: create user xxx with md5 string?

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