Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id DC6A0634B60
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 14 Aug 2009 06:28:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 08902-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 14 Aug 2009 09:28:09 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.171])
	by mail.postgresql.org (Postfix) with ESMTP id 1F9D7633C50
	for <pgsql-sql@postgresql.org>; Fri, 14 Aug 2009 06:28:00 -0300 (ADT)
Received: by wf-out-1314.google.com with SMTP id 28so396978wfc.28
	for <pgsql-sql@postgresql.org>; Fri, 14 Aug 2009 02:27:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:from:to
	:content-type:content-transfer-encoding:mime-version:subject:date
	:x-mailer; bh=8SQNuOOoQO9BPIXBuvr04X3wxpgFu4LqkppbHz9rLoM=;
	b=kxv6EmjgFSfMJfuserc+4NlvbYHofb3dg8TxSNem/AJgF1pruMggh6V4P3WrpyPnpo
	URMrJbFSpNC9sevZ50fW1VED/B1ZliplBl2bISztpWZwc8cX4v8LvxeO5nwuwKV1WbXb
	OjdgcpvENBd/offnijxzIROuU0+NheSuHxDLw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:from:to:content-type:content-transfer-encoding
	:mime-version:subject:date:x-mailer;
	b=rj0oQqYndEM/0HdX/SGDIDlbB4BfnM2F3bGEOxptz/jPQAQSTL1l7X/0nQZAhYYyxe
	P5EpQkIBJ0NZi6vVI53zSX30y9kp6UdJyAWXUsmEkk+QExoiLw2s52E2Wq+u72rAwZKC
	H4vJZP04lv3psBzP/DHBtPRD9Ad4svG86DCKo=
Received: by 10.142.210.13 with SMTP id i13mr271003wfg.147.1250242079731;
	Fri, 14 Aug 2009 02:27:59 -0700 (PDT)
Received: from ?192.168.0.112? ([125.162.244.7])
	by mx.google.com with ESMTPS id 28sm3360870wfd.24.2009.08.14.02.27.56
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 14 Aug 2009 02:27:58 -0700 (PDT)
Message-Id: <697B993A-8A8A-4271-AE98-B7BB4D192608@gmail.com>
From: Hengky Lie <hengkyliwandouw@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Field or record level encryption / decryption
Date: Fri, 14 Aug 2009 17:20:58 +0800
X-Mailer: Apple Mail (2.935.3)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200908/75
X-Sequence-Number: 32984

Hi,

Anyone know what function i can use to encrypt /  decrypt field or  
record ?

When record saved, it saved in encrypt format. When i need to read  
data, i just call decrypt function.

I am using MS Access 2003 and Postgresql 8.3

Thanks a lot.

Regards,

Hengky