Re: Encrypting a single column

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