Re: [SQL] [GENERAL] pgcrypto-crypt

2006-04-10 Thread chris smith
On 4/6/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: > dear all, > i want to encrypt and decrypt one of the fields in my table (i.e-password > field) > i have searched and with the help of pgcrypto package, using function > "crypt", i am able to encrypt my data, > but there is nothing which i fo

Re: [SQL] [GENERAL] pgcrypto-crypt

2006-04-10 Thread Chris
AKHILESH GUPTA wrote: how do we compare the existing data in the table with the entered one? same way as anything else, for example: select * from users where passwd=md5('my_password'); is there any other function which we can use here for both cases encryption as well as for decryption at t