Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: pgcrypto-crypt
Date: Thu, 6 Apr 2006 11:31:41 -0700
Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC2883A8@nelson.osl.com>
Thread-Topic: [SQL] pgcrypto-crypt
Thread-Index: AcZZpz+mOiZU6O3DTXGkWzBxHwxvXgAAE6/w
From: "Owen Jacobson" <ojacobson@osl.com>
To: <pgsql-sql@postgresql.org>

Guy Fraser wrote:
=20
> On Thu, 2006-06-04 at 13:53 +0530, AKHILESH GUPTA 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,

The 'crypt' function in pgcrypto is analogous to the unix crypt(3) =
function, which is actually a hashing function and not an encryption =
function -- meaning you *can't* (realistically) decrypt it.  Use =
'encrypt', as demonstrated below.


> INSERT INTO crypto VALUES (1,'test1',encrypt('daniel', 'fooz', =
'aes'));
> INSERT INTO crypto VALUES (2,'test2',encrypt('struck', 'fooz', =
'aes'));
> INSERT INTO crypto VALUES (3,'test3',encrypt('konz', 'fooz', 'aes'));
>=20
> SELECT * FROM crypto;
>=20
> SELECT *,decrypt(crypted_content, 'fooz', 'aes') FROM crypto;
>=20
> SELECT *,decrypt(crypted_content, 'fooz', 'aes') FROM crypto WHERE
> decrypt(crypted_content, 'fooz', 'aes') =3D 'struck';
>=20
> I could not test it, since I do not have pgcrypto installed.

This works perfectly.