Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E15A72E3D13 for ; Fri, 14 Dec 2007 13:37:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 89835-03-5 for ; Fri, 14 Dec 2007 13:37:24 -0400 (AST) Received: from n6.bullet.mud.yahoo.com (n6.bullet.mud.yahoo.com [216.252.100.57]) by postgresql.org (Postfix) with SMTP id 8F17B2E4358 for ; Fri, 14 Dec 2007 13:35:58 -0400 (AST) Received: from [68.142.194.244] by n6.bullet.mud.yahoo.com with NNFMP; 14 Dec 2007 17:35:57 -0000 Received: from [209.191.119.173] by t2.bullet.mud.yahoo.com with NNFMP; 14 Dec 2007 17:35:57 -0000 Received: from [127.0.0.1] by omp104.mail.mud.yahoo.com with NNFMP; 14 Dec 2007 17:35:57 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 240566.4645.bm@omp104.mail.mud.yahoo.com Received: (qmail 44912 invoked by uid 60001); 14 Dec 2007 17:35:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=NlFbt/GSX+SggZ+wdprAWQOHzlEjG2psf24XV48/QlDqdd4QMA89Mpkagg/zt2rcEAfsNWFzep5t5qOqeY0JlHvH41Q1MKvwYmHTj6ci/dRiwlxz0f7O0lSAJZizOMTNjU10r+8z6Z1DQIfSA6UK2MGP7vB3LK/P1LYvEGsEHzc=; X-YMail-OSG: 4gMKQhEVM1nmtqrEIZ9AMo5Gx8hAj_8.VlsEJ0Xlz1wfBoJ.LQmyeyPaIiIACEdqcPZS6wjrSu.vveAiYrzBREQP795WBI8ZqDthflt81XkOmEGLGzmNaGNMBixDg32X1VJC_lPpbQff8Q-- Received: from [83.166.184.142] by web25809.mail.ukl.yahoo.com via HTTP; Fri, 14 Dec 2007 17:35:55 GMT Date: Fri, 14 Dec 2007 17:35:55 +0000 (GMT) From: Glyn Astill Subject: Re: Encrypting a single column To: pgsql-admin@postgresql.org In-Reply-To: <659515.22036.qm@web25809.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <934041.43387.qm@web25809.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/107 X-Sequence-Number: 27624 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 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@postgresql.org 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