richard terry schrieb:
> I wondered if it was possible to see what the original password put in was if
> one does a select * from pg_shadow where user = 'the_user'; and you end up
> with passwd as a great big long string.
>
> regards
>
> Ricahrd
>
Hi,
all passwords are stored as MD5 strings in PostgreSQL. MD5 is a one way
encryption. So as long as you do not use a paramater (-N) while creating
a new user, the password will be encrypted and you cannot see it in
plain text.
Cheers
Andy
--
St.Pauli - Hamburg - Germany
Andreas Wenk
