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 > [EMAIL PROTECTED] > ===================== > > > -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general