From: Hengky Lie <hengkyliwandouw@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Field or record level encryption / decryption
Date: Sat, 15 Aug 2009 00:07:54 +0800
Message-ID: <B0DCC3D1-A4B7-48B3-B0BD-B38333A56CC0@gmail.com> (raw)
In-Reply-To: <8763cqqv4c.fsf@dba2.int.libertyrms.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hengkyliwandouw@gmail.com
Subject: Re: Field or record level encryption / decryption
In-Reply-To: <B0DCC3D1-A4B7-48B3-B0BD-B38333A56CC0@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox