I'm looking for a simple way to encrypt the contents of a text field in one
of my Postgres tables. I'm not looking for anything that is bullet-proof --
just something that would mask the field's contents from a casual user
looking at the table via pgAdminIII or any other client application / query.
I'm hoping there is a built-in Postgres function that I could call from my
java web application to encrypt/mask a text string and then store the
encrypted value in the DB. Thereafter, I would be able to query the
encrypted field, de-crypt back to the original value, etc.
Any suggestions would be appreciated.
BTW...I'm using Postgres v8.3 on Windows Server
pgsql-novice by date
|Next:||From: Daniel Malcolm Webb [dbw]||Date: 2008-10-22 13:56:03|
|Subject: FW: Dumping a query result to a table|
|Previous:||From: Scott Porter||Date: 2008-10-21 15:23:28|
|Subject: copy from csv|