I need to ecrypt one column to an output file

Ralph Smith wrote:

I need to do a simple query and output to a file.
No problem.

But how do I encrypt one column's output?

There are lots of developer related links here, and info to "use the
/contrib pgcrypto", but I'm not a PG developer and I failed to find any
info on HOW TO USE that library function...

Have you installed the pgcrypto module?
Have you read the guide to pgcrypto in the manual?
http://www.postgresql.org/docs/8.3/static/pgcrypto.html

--
Richard Huxton
Archonet Ltd

Ralph Smith wrote:

I need to do a simple query and output to a file.
No problem.
But how do I encrypt one column's output?
There are lots of developer related links here, and info to "use
the /contrib pgcrypto", but I'm not a PG developer and I failed to
find any info on HOW TO USE that library function...

=============================
On Apr 15, 2008, at 11:31 PM, Richard Huxton wrote:

Have you installed the pgcrypto module?
Have you read the guide to pgcrypto in the manual?
http://www.postgresql.org/docs/8.3/static/pgcrypto.html

--
Richard Huxton
Archonet Ltd

==============================
I'm still too dense to get it. I'm sorry.

* Where would I look to see if it is installed?
(I'm not the SA who did the install, nor do I have those privs.)

* If not, must he go the source install route, (we're using Ubuntu),
or via synaptic package installer (for PG v8.2)?

If it is there, I'm still too much a newbie to find the text to tell
me how to use it.
I don't want to be totally hand held, but I need to find the HOW-TO
guide(s).

* What I want to do (right now) is simply encode usernames onto a
hard copy.
* What I will want to do in the future is to encode usernames INTO
the DB.

Thanks again,

Ralph Smith
=====================

On Tue, Apr 15, 2008 at 01:11:10PM -0700, Ralph Smith wrote:

I need to do a simple query and output to a file.
No problem.

But how do I encrypt one column's output?

COPY (SELECT a, b, c, some_func(d) AS d_s3krit FROM your_tab) TO...;

Does that help?

Cheers,
David.

There are lots of developer related links here, and info to "use the
/contrib pgcrypto", but I'm not a PG developer and I failed to find any
info on HOW TO USE that library function...

Thanks all,

Ralph Smith
smithrn@washington.edu
=====================

--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate