Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1898C2E3005 for ; Fri, 14 Dec 2007 14:03:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14922-06 for ; Fri, 14 Dec 2007 14:03:51 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id CFABE2E2F64 for ; Fri, 14 Dec 2007 14:03:50 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 13A7DB2535 for ; Fri, 14 Dec 2007 19:03:47 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Dw5r8iuJAgEi for ; Fri, 14 Dec 2007 19:03:47 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id F0B84B2533; Fri, 14 Dec 2007 19:03:46 +0100 (CET) Date: Fri, 14 Dec 2007 19:03:46 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Encrypting a single column Message-ID: <20071214180346.GB30811@easy2.in-chemnitz.de> References: <659515.22036.qm@web25809.mail.ukl.yahoo.com> <47626F12.EE98.0025.0@wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <47626F12.EE98.0025.0@wicourts.gov> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/111 X-Sequence-Number: 27628 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