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

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

2008-04-16 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

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

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

2008-04-15 Thread Ralph Smith
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...