Re: How to store a password encripted in a userdefinedtable

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>, "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be>
Subject: Re: How to store a password encripted in a userdefinedtable
Date: 2007-03-01 17:19:04
Message-ID: 200703010919.05035.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)comcast(dot)net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-03-01 18:02:13 Re: How to store a password encripted in a userdefinedtable
Previous Message Shane Ambler 2007-03-01 17:14:15 Re: How to store a password encripted in a userdefinedtable