Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F2BED2E4BE2 for ; Fri, 14 Dec 2007 12:43:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38496-02-9 for ; Fri, 14 Dec 2007 12:43:50 -0400 (AST) Received: from n7.bullet.mud.yahoo.com (n7.bullet.mud.yahoo.com [216.252.100.58]) by postgresql.org (Postfix) with SMTP id E0E192E4539 for ; Fri, 14 Dec 2007 12:30:47 -0400 (AST) Received: from [209.191.108.96] by n7.bullet.mud.yahoo.com with NNFMP; 14 Dec 2007 16:30:47 -0000 Received: from [209.191.90.55] by t3.bullet.mud.yahoo.com with NNFMP; 14 Dec 2007 16:30:47 -0000 Received: from [127.0.0.1] by omp108.mail.mud.yahoo.com with NNFMP; 14 Dec 2007 16:30:47 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 56237.12483.bm@omp108.mail.mud.yahoo.com Received: (qmail 23154 invoked by uid 60001); 14 Dec 2007 16:30:45 -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:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=od5umrc6e3SCIBtEJGYZ7o6iCzPPPM7TEpoQSFVvdTIu9lw8kIikEjrQQpQxxGhN2FuZ1I7Tgu/wBHfnDS3vuFigsR9gpkV3w2qsWhGTU+vHBwNUsUBRISEIQ4ZBYhrfoxYXhRx9gHS7x0g18n4z0B4/UGwbqfwAECHJhibcvBo=; X-YMail-OSG: HxN01.kVM1mpvt54ueH2Ot2pR8qbQKWSe3ABdp23ZgsnaxJMUBkgARAXjXhThSfnBarBS2VTSAApndIGG4GUTt.SdIleI8lAYRt7POqKgVimjpRMO7GKmgMeUpQ- Received: from [83.166.184.142] by web25809.mail.ukl.yahoo.com via HTTP; Fri, 14 Dec 2007 16:30:45 GMT Date: Fri, 14 Dec 2007 16:30:45 +0000 (GMT) From: Glyn Astill Subject: Encrypting a single column To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <659515.22036.qm@web25809.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/106 X-Sequence-Number: 27623 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