Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 235AF2E0176 for ; Fri, 14 Dec 2007 13:55:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 92888-02-3 for ; Fri, 14 Dec 2007 13:55:09 -0400 (AST) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 4B2FE2E017C for ; Fri, 14 Dec 2007 13:55:10 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 14 Dec 2007 11:55:09 -0600 Message-Id: <47626F12.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 14 Dec 2007 11:54:58 -0600 From: "Kevin Grittner" To: , "Glyn Astill" Subject: Re: Encrypting a single column References: <659515.22036.qm@web25809.mail.ukl.yahoo.com> In-Reply-To: <659515.22036.qm@web25809.mail.ukl.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/109 X-Sequence-Number: 27626 >>> On Fri, Dec 14, 2007 at 10:30 AM, in message <659515.22036.qm@web25809.mail.ukl.yahoo.com>, Glyn Astill wrote:=20 > We need to encrypt an individual column in a table. I've noticed that > pgcrypto can do this. >=20 > 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. =20 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. Get the vendor to support what you need or replace the layer with something which has better support (or that you can support yourselves). =20 Any solution which includes what's necessary for decryption in the dump will not really be much of a solution. =20 If you're trying to protect against something else, please clarify. =20 -Kevin =20