Re: Simple Text Field Encryption - Mailing list pgsql-novice

From Bruce Hyatt
Subject Re: Simple Text Field Encryption
Date
Msg-id 406138.52368.qm@web34403.mail.mud.yahoo.com
Whole thread Raw
In response to Simple Text Field Encryption  ("gcj" <gauss21@comcast.net>)
List pgsql-novice
--- On Tue, 10/21/08, gcj <gauss21@comcast.net> wrote:

> From: gcj <gauss21@comcast.net>
> Subject: [NOVICE] Simple Text Field Encryption
> To: pgsql-novice@postgresql.org
> Date: Tuesday, October 21, 2008, 1:11 PM
> 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.

Since you're using java, maybe there's a way to use a JPasswordField object?

Bruce




pgsql-novice by date:

Previous
From: "Daniel Malcolm Webb [dbw]"
Date:
Subject: Re: FW: Dumping a query result to a table
Next
From: "Damian Carey"
Date:
Subject: Re: Simple Text Field Encryption