Re: Field or record level encryption / decryption

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