pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to do a select * and decrypt a column at the same time?
3+ messages / 3 participants
[nested] [flat]
* how to do a select * and decrypt a column at the same time?
@ 2005-08-16 19:53 The One <i51359@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: The One @ 2005-08-16 19:53 UTC (permalink / raw)
To: pgsql-sql
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?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to do a select * and decrypt a column at the same time?
@ 2005-08-16 21:05 Bruno Wolff III <bruno@wolff.to>
parent: The One <i51359@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Bruno Wolff III @ 2005-08-16 21:05 UTC (permalink / raw)
To: The One <i51359@yahoo.com>; +Cc: pgsql-sql
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 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to do a select * and decrypt a column at the same
@ 2005-08-24 20:46 Scott Marlowe <smarlowe@g2switchworks.com>
parent: The One <i51359@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2005-08-24 20:46 UTC (permalink / raw)
To: The One <i51359@yahoo.com>; +Cc: 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...
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-24 20:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-16 19:53 how to do a select * and decrypt a column at the same time? The One <i51359@yahoo.com>
2005-08-16 21:05 ` Bruno Wolff III <bruno@wolff.to>
2005-08-24 20:46 ` Re: how to do a select * and decrypt a column at the same Scott Marlowe <smarlowe@g2switchworks.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox