Re: [GENERAL] How to encrypt data in Postgresql

2003-07-25 Thread Richard Welty
On Fri, 25 Jul 2003 09:33:30 -0400 "Reuben D. Budiardja" <[EMAIL PROTECTED]> wrote: > I think if you encrypt MD5 before storing it into the table, then there > is no > way to retrieve the corresponding clear text right? since MD5 is one-way > encryption.. yes, but normally when doing passwords,

Re: [GENERAL] How to encrypt data in Postgresql

2003-07-25 Thread Reuben D. Budiardja
On Thursday 24 July 2003 02:59 pm, Franco Bruno Borghesi wrote: > You must install pgcrypto (its in your contrib/pgcrypto directory). > > Then, the functions crypt and gen_salt will become available. > > As an example, to insert a new user (peter) with an encrypted password > (1234) you can do: > I