DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=date:from:to:cc:subject:message-id:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=TEbLlG4is3sMu0hEEpwo24/7l5Ss/d9r9a6svZ5N0j7cRWXOm874WkHxklQwwbYkPl
	yQ9UjVjqsO9S5KE8TgqrRtQ2Y5YiO7VKLu3shc1KRo7iNTGdgEQEJvFmJDlZPqR7mdgf
	IPJBdYmGcT//3ZENetPAl7/X1kQa9gBdIyeJM=
Date: Fri, 14 Aug 2009 07:24:16 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Hengky Lie <hengkyliwandouw@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Field or record level encryption / decryption
Message-ID: <20090814132416.GC4696@eddie>
References: <697B993A-8A8A-4271-AE98-B7BB4D192608@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="VywGB/WGlW4DM4P8"
Content-Disposition: inline
In-Reply-To: <697B993A-8A8A-4271-AE98-B7BB4D192608@gmail.com>
User-Agent: Mutt/1.5.18 (2008-05-17)


--VywGB/WGlW4DM4P8
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Aug 14, 2009 at 05:20:58PM +0800, Hengky Lie wrote:
> Hi,
>
> Anyone know what function i can use to encrypt /  decrypt field or =20
> record ?
>
> When record saved, it saved in encrypt format. When i need to read data,=
=20
> i just call decrypt function.

See the pgcrypto extension:
http://www.postgresql.org/docs/current/static/pgcrypto.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--VywGB/WGlW4DM4P8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkqFZYAACgkQRiRfCGf1UMPNcwCgkYkPvTZpdGMficgN4+LLjjPO
80MAnitHPXeMe94uNR45NApmEXgYuH58
=nHUw
-----END PGP SIGNATURE-----

--VywGB/WGlW4DM4P8--