Re: [GENERAL] pgcrypto-crypt

2006-04-06 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

Re: [GENERAL] pgcrypto-crypt

2006-04-06 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

[GENERAL] pgcrypto-crypt

2006-04-06 Thread AKHILESH GUPTA
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 found to decrypt that same data, plz anybody give me the function to d