Skip site navigation (1) Skip section navigation (2)

Encrypting a single column

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Encrypting a single column
Date: 2007-12-14 16:30:45
Message-ID: 659515.22036.qm@web25809.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: 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



Responses

pgsql-admin by date

Next:From: Glyn AstillDate: 2007-12-14 17:35:55
Subject: Re: Encrypting a single column
Previous:From: Anibal AcostaDate: 2007-12-14 15:16:45
Subject: Corrupt backup file after pg_dump (from windows)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group