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 <glynastill@xxxxxxxxxxx> wrote: > 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 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an > appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that > your > message can get through to the mailing list cleanly > Glyn Astill __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org