Re: How to store a password encripted in a userdefinedtable - Mailing list pgsql-sql

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
>


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