Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 5F4ED9FB3B2
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 14:02:28 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 64509-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 14:02:15 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174])
	by postgresql.org (Postfix) with ESMTP id 752D69FB24B
	for <pgsql-sql@postgresql.org>; Thu,  1 Mar 2007 14:02:15 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so390331ugf
	for <pgsql-sql@postgresql.org>; Thu, 01 Mar 2007 10:02:13 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=QN4M1ZI/EHYNmTcqTwuZwtnTdJcDdZCtnRg4+3YsVb7TMJtgHaCb+Pvr8ciKwLad06M1Dhb4JSNhpsQeC/Y2XtOWA4nbnBEGDqmnfAQ4U0WN2YOcsCYMFu6FZh2zMa9RR0Nw3uZPue4sUXRyFbJnrioBXXrpqzzBZFYWNOc24Ps=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=HFE9l7sJ4MjLDECrI4jtX5x39jPc3If30RlOTP7Tbx90z/XKYqwHNGpL4kchV+VfsAaSsjMmAHdLpoxGjcYJM3VaXQ6TLmQDqq+GtofvePl4PEthFgCxrBJt4DqYuccJif7EJIJEVxr3H1D+Ea/Rw8vklWdOzdKgWJJde26UggI=
Received: by 10.67.99.1 with SMTP id b1mr2429852ugm.1172772133236;
	Thu, 01 Mar 2007 10:02:13 -0800 (PST)
Received: by 10.67.94.13 with HTTP; Thu, 1 Mar 2007 10:02:13 -0800 (PST)
Message-ID: <55c095e90703011002j6deb43e5n4ce40459b2ba8d96@mail.gmail.com>
Date: Thu, 1 Mar 2007 15:02:13 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Adrian Klaver" <aklaver@comcast.net>
Subject: Re: How to store a password encripted in a userdefinedtable
Cc: pgsql-sql@postgresql.org, "Bart Degryse" <Bart.Degryse@indicator.be>
In-Reply-To: <200703010919.05035.aklaver@comcast.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <675205.64473.qm@web55615.mail.re4.yahoo.com>
	<45E6FC74.A3DD.0030.0@indicator.be>
	<55c095e90703010853n2e34a260pd7fb8e9430d789a@mail.gmail.com>
	<200703010919.05035.aklaver@comcast.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/19
X-Sequence-Number: 27657

Perfect ! That's it.

Another information I doesn't have. Great to be part of this list.

Thank you
Adrian


2007/3/1, Adrian Klaver <aklaver@comcast.net>:
> 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
>


--=20
 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/