Re: pgcrypto-crypt

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 the script as well as database
> level....

why do you need it encrypted?

Please do reply-all - you will get a quicker response (from me and the
list(s) might have suggestions I don't).

> On 4/6/06, *chris smith* <dmagick(at)gmail(dot)com <mailto:dmagick(at)gmail(dot)com>>
> wrote:
>
> On 4/6/06, AKHILESH GUPTA <akhilesh(dot)davim(at)gmail(dot)com
> <mailto:akhilesh(dot)davim(at)gmail(dot)com>> 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 found to decrypt that same data,
> > plz anybody give me the function to decrypt that encrypted
> value.....
>
> The crypt function can't be decrypted (whether it's in postgresql or
> anywhere else).
>
> Crypt is meant to be used for passwords and such that you don't need
> to reverse (you only compare against).
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>
>
>
> --
> Thanks & Regards,
> Akhilesh
> DAV Institute of Management
> Faridabad(Haryana)
> GSM:-(+919891606064)
> (+911744293789)
>
> "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

--
Postgresql & php tutorials
http://www.designmagick.com/