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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql