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 <[EMAIL PROTECTED]>:
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
[EMAIL PROTECTED]
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
