Re: [GENERAL] I need to ecrypt one column to an output file

2008-04-19 Thread David Fetter
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 dev

Re: [GENERAL] I need to ecrypt one column to an output file

2008-04-16 Thread Ralph Smith
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 libr

Re: [GENERAL] I need to ecrypt one column to an output file

2008-04-15 Thread Richard Huxton
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 libra