Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 39D17632ABE
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 15:39:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 10550-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  3 Dec 2009 19:39:09 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1])
	by mail.postgresql.org (Postfix) with ESMTP id B265B632AC3
	for <pgsql-sql@postgresql.org>; Thu,  3 Dec 2009 15:39:09 -0400 (AST)
Received: from [157.92.152.105] (unknown [157.92.152.105])
	by mail.fmed.uba.ar (Postfix) with ESMTP id C5B7C39C527;
	Thu,  3 Dec 2009 16:37:57 -0200 (ARST)
Message-ID: <4B180B62.6060907@fmed.uba.ar>
Date: Thu, 03 Dec 2009 16:02:58 -0300
From: Gerardo Herzig <gherzig@fmed.uba.ar>
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: postgres list <pgsql-sql@postgresql.org>
Subject: Re: create user xxx with md5 string?
References: <4B17FDCE.6030200@fmed.uba.ar> <12517.1259868079@sss.pgh.pa.us>
In-Reply-To: <12517.1259868079@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 200912/6
X-Sequence-Number: 33444

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