Re: pgcrypto-crypt

From: "chris smith" <dmagick(at)gmail(dot)com>
To: "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: pgcrypto-crypt
Date: 2006-04-06 08:53:17
Message-ID: 3c1395330604060153p4d773e0fu574a190de1fa4d9a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On 4/6/06, AKHILESH GUPTA <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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2006-04-06 10:39:31 Re: stored proc vs sql query string
Previous Message AKHILESH GUPTA 2006-04-06 08:23:26 pgcrypto-crypt

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-04-06 09:28:00 Re: SELECT composite type
Previous Message AKHILESH GUPTA 2006-04-06 08:23:26 pgcrypto-crypt