X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2092C52883 for ; Tue, 16 Aug 2005 18:03:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01243-05 for ; Tue, 16 Aug 2005 21:03:49 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 369705287D for ; Tue, 16 Aug 2005 18:03:48 -0300 (ADT) Received: (qmail 31907 invoked by uid 500); 16 Aug 2005 21:05:34 -0000 Date: Tue, 16 Aug 2005 16:05:33 -0500 From: Bruno Wolff III To: The One Cc: pgsql-sql@postgresql.org Subject: Re: how to do a select * and decrypt a column at the same time? Message-ID: <20050816210533.GA29260@wolff.to> Mail-Followup-To: Bruno Wolff III , The One , pgsql-sql@postgresql.org References: <20050816195351.632.qmail@web33911.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050816195351.632.qmail@web33911.mail.mud.yahoo.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/117 X-Sequence-Number: 22345 On Tue, Aug 16, 2005 at 12:53:51 -0700, The One wrote: > Hello, > > I have a table with one encrypted column. > How can I do a select statement such that it will select all columns from the table and at the same time will decrypt it too? You want to explicitly list all of the column names in the select list, except for the encrypted column for which you should call the decryption function.