Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: how to do a select * and decrypt a column at the same
Date
Msg-id 1124916366.28179.28.camel@state.g2switchworks.com
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, 2005-08-16 at 14:53, 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?

A view should be able to do that...

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Number of rows in a cursor ?
Next
From: "Lane Van Ingen"
Date:
Subject: Can EXCEPT Be Used for To Solve This Problem?