Re: how to do a select * and decrypt a column at the same

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: The One <i51359(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to do a select * and decrypt a column at the same
Date: 2005-08-24 20:46:06
Message-ID: 1124916366.28179.28.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lane Van Ingen 2005-08-24 20:47:16 Can EXCEPT Be Used for To Solve This Problem?
Previous Message Michael Fuhr 2005-08-24 17:46:12 Re: Number of rows in a cursor ?