Re: [GENERAL] pgcrypto-crypt - Mailing list pgsql-sql

From chris smith
Subject Re: [GENERAL] pgcrypto-crypt
Date
Msg-id 3c1395330604060153p4d773e0fu574a190de1fa4d9a@mail.gmail.com
Whole thread Raw
In response to pgcrypto-crypt  ("AKHILESH GUPTA" <akhilesh.davim@gmail.com>)
List pgsql-sql
On 4/6/06, AKHILESH GUPTA <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/

pgsql-sql by date:

Previous
From: Chris
Date:
Subject: Re: [GENERAL] pgcrypto-crypt
Next
From: FavoYang@gmail.com
Date:
Subject: slow 'IN' clause