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* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    On 4/6/06, AKHILESH GUPTA <[EMAIL PROTECTED]
    <mailto:[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 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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to