From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-sql@postgresql.org
Cc: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: Bart Degryse <Bart.Degryse@indicator.be>
Subject: Re: How to store a password encripted in a userdefinedtable
Date: Thu, 1 Mar 2007 09:19:04 -0800
Message-ID: <200703010919.05035.aklaver@comcast.net> (raw)
In-Reply-To: <55c095e90703010853n2e34a260pd7fb8e9430d789a@mail.gmail.com>
References: <675205.64473.qm@web55615.mail.re4.yahoo.com>
<45E6FC74.A3DD.0030.0@indicator.be>
<55c095e90703010853n2e34a260pd7fb8e9430d789a@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aklaver@comcast.net, ezequias.rocha@gmail.com, Bart.Degryse@indicator.be
Subject: Re: How to store a password encripted in a userdefinedtable
In-Reply-To: <200703010919.05035.aklaver@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox