Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id CF1F99FBE47
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 13:18:29 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 98989-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 13:18:22 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from rwcrmhc15.comcast.net (rwcrmhc15.comcast.net [204.127.192.85])
	by postgresql.org (Postfix) with ESMTP id D7E619FBD9B
	for <pgsql-sql@postgresql.org>; Thu,  1 Mar 2007 13:18:21 -0400 (AST)
Received: from [192.168.0.9]
 (c-24-17-161-80.hsd1.wa.comcast.net[24.17.161.80])
	by comcast.net (rwcrmhc15) with ESMTP
	id <20070301171820m15004sacde>; Thu, 1 Mar 2007 17:18:20 +0000
From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Subject: Re: How to store a password encripted in a userdefinedtable
Date: Thu, 1 Mar 2007 09:19:04 -0800
User-Agent: KMail/1.9.1
Cc: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>,
	"Bart Degryse" <Bart.Degryse@indicator.be>
References: <675205.64473.qm@web55615.mail.re4.yahoo.com>
	<45E6FC74.A3DD.0030.0@indicator.be>
	<55c095e90703010853n2e34a260pd7fb8e9430d789a@mail.gmail.com>
In-Reply-To: <55c095e90703010853n2e34a260pd7fb8e9430d789a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200703010919.05035.aklaver@comcast.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.709 tagged_above=0 required=5 tests=BAYES_50,
	DNS_FROM_RFC_POST
X-Spam-Level: *
X-Archive-Number: 200703/18
X-Sequence-Number: 27656

On Thursday 01 March 2007 8:53 am, Ezequias Rodrigues da Rocha wrote:
> I am just passing the database owner password (postgresql
> autentication) to the statement:
>
> Select md5('the password I have in my mind') and compare with the
> password pgAdmin3 shows me.
>
> They are completely different.
>
> Ezequias
>
<Snip>
Try select md5('password'||'user')
The generated hash is a combination of the password and the user name.
-- 
Adrian Klaver
aklaver@comcast.net