Postgres Pro
Downloads
Home   >   mailing lists

Re: how to do a select * and decrypt a column at the same time? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: how to do a select * and decrypt a column at the same time?
Date
Msg-id 20050816210533.GA29260@wolff.to
Whole thread Raw
In response to how to do a select * and decrypt a column at the same time?  (The One <i51359@yahoo.com>)
List pgsql-sql
Tree view 
On Tue, Aug 16, 2005 at 12:53:51 -0700, The One <i51359@yahoo.com> 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
ittoo?
 

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.

pgsql-sql by date:

Previous
From: The One
Date:
Subject: how to do a select * and decrypt a column at the same time?
Next
From: tv@fuzzy.cz
Date:
Subject: converting varchar to integer