Re: create user xxx with md5 string?

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: create user xxx with md5 string?
Date: 2009-12-03 19:02:58
Message-ID: 4B180B62.6060907@fmed.uba.ar
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
> Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-12-03 19:21:19 Re: create user xxx with md5 string?
Previous Message Gerardo Herzig 2009-12-03 18:05:02 create user xxx with md5 string?