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 postgres dbms, so > > our programs cant sent an individual sql statement to give the > > password. > > I assume that you're trying to protect against a backup of the > database falling into the wrong hands? If so, your connectivity > layer should be doing the work. I think, he should go for encrypted backup instead if that's what he wants to accomplish. > If you're trying to protect against something else, please clarify. +1 Bye, Tino. -- www.craniosacralzentrum.de www.lebensraum11.de www.spiritualdesign-chemnitz.de Tino Schwarze * Parkstraße 17h * 09120 Chemnitz ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate