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:

hengkyliwand...@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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to