Re: pgcrypto-crypt - Mailing list pgsql-general

From Chris
Subject Re: pgcrypto-crypt
Date
Msg-id 44359520.2060407@gmail.com
Whole thread Raw
In response to pgcrypto-crypt  ("AKHILESH GUPTA" <akhilesh.davim@gmail.com>)
List pgsql-general
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@gmail.com <mailto:dmagick@gmail.com>>
> wrote:
>
>     On 4/6/06, AKHILESH GUPTA <akhilesh.davim@gmail.com
>     <mailto:akhilesh.davim@gmail.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/

pgsql-general by date:

Previous
From: "Antimon"
Date:
Subject: Large text data
Next
From: Guy Fraser
Date:
Subject: Re: Backup method