DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:from:to:in-reply-to:content-type
	:content-transfer-encoding:mime-version:subject:date:references
	:x-mailer;
	b=wXOnv137GqWF3KLookLDJAMQZTRElNIW6N1r6LZ6xtnh9LVnNG0qvSKZ94OjjXueH7
	Evd7+ytIcRLJ+bOi0SuaES6/M5I3IxLS70cDkdApMvZy3PWA3/BrhuEvwKrWgqTz5gWX
	JoUQAHQSpSAYp9D7YVoBtYgEzAFMI77wLwyWU=
Message-Id: <B0DCC3D1-A4B7-48B3-B0BD-B38333A56CC0@gmail.com>
From: Hengky Lie <hengkyliwandouw@gmail.com>
To: pgsql-sql@postgresql.org
In-Reply-To: <8763cqqv4c.fsf@dba2.int.libertyrms.com>
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: Re: Field or record level encryption / decryption
Date: Sat, 15 Aug 2009 00:07:54 +0800
References: <697B993A-8A8A-4271-AE98-B7BB4D192608@gmail.com>
	<8763cqqv4c.fsf@dba2.int.libertyrms.com>

Thanks to all who response my question.

I have checked the doc, but it seems too advance for my postgresql  
knowledge.

Other question is where can i get pgcrypto modules ?

For simple record encryption that contains date field, varchar,  
integer and text, what encryption i can use ? As far as i know, there  
is no way to return MD5 result back to its original value. Is this  
true or not ?

Thanks a lot


On Aug 14, 2009, at 11:21 PM, Christopher Browne wrote:

> hengkyliwandouw@gmail.com (Hengky Lie) writes:
>> 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
>
> I'd suggest referring to the fine manual...
> http://www.postgresql.org/docs/8.3/static/pgcrypto.html
> -- 
> output = reverse("ofni.sailifa.ac" "@" "enworbbc")
> Christopher Browne
> "Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
> phasers on the Heffalump, Piglet, meet me in transporter room three"
>
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql