Encrypting a single column - Mailing list pgsql-admin

From Glyn Astill
Subject Encrypting a single column
Date
Msg-id 659515.22036.qm@web25809.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Encrypting a single column  (Glyn Astill <glynastill@yahoo.co.uk>)
Re: Encrypting a single column  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Hi people,

We need to encrypt an individual column in a table. I've noticed that
pgcrypto can do this.

However we have one problem, our software runs through a closed
source "connectivity kit" that allows it to use a postgres dbms, so
our programs cant sent an individual sql statement to give the
password.

The column we want to encrypt is used in thousands of programs so
it's hard for us to change all the programs to encrypt / decrypt the
column

Can anyone see any way around this?


      __________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com



pgsql-admin by date:

Previous
From: olivier boissard
Date:
Subject: Re: improve performance in a big table
Next
From: Glyn Astill
Date:
Subject: Re: Encrypting a single column