Re: [ADMIN] Encrypting a single column

2007-12-14 Thread Tino Schwarze
On Fri, Dec 14, 2007 at 11:54:58AM -0600, Kevin Grittner wrote: > > 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 postgre

Re: [ADMIN] Encrypting a single column

2007-12-14 Thread Kevin Grittner
>>> On Fri, Dec 14, 2007 at 10:30 AM, in message <[EMAIL PROTECTED]>, Glyn Astill <[EMAIL PROTECTED]> wrote: > 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

Re: [ADMIN] Encrypting a single column

2007-12-14 Thread Glyn Astill
I guess a simpler way to say this is; is there a way we can make a column in postgres to be encrypted but entirely transparent to the user? Could we do this with phgcrypto + some form of trigger or view etc? --- Glyn Astill <[EMAIL PROTECTED]> wrote: > Hi people, > > We need to encrypt an indiv

[ADMIN] Encrypting a single column

2007-12-14 Thread Glyn Astill
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