Re: [GENERAL] around fields with psql

2012-02-13 Thread Jasen Betts
On 2012-02-10, Steve Clark scl...@netwolves.com wrote: Is there a way with psql to get column output to be data1,data2,...,datan assuming you are trying to be compatible with CSV: copy ( your_query_here ) to stdout with csv header ; -- ⚂⚃ 100% natural -- Sent via pgsql-general

Re: [GENERAL] around fields with psql

2012-02-13 Thread Merlin Moncure
On Sat, Feb 11, 2012 at 2:03 AM, Jasen Betts ja...@xnet.co.nz wrote: On 2012-02-10, Steve Clark scl...@netwolves.com wrote: Is there a way with psql to get column output to be data1,data2,...,datan assuming you are trying to be compatible with CSV:  copy ( your_query_here ) to stdout with

Re: [GENERAL] around fields with psql

2012-02-13 Thread Steve Clark
On 02/13/2012 02:13 PM, Merlin Moncure wrote: On Sat, Feb 11, 2012 at 2:03 AM, Jasen Bettsja...@xnet.co.nz wrote: On 2012-02-10, Steve Clarkscl...@netwolves.com wrote: Is there a way with psql to get column output to be data1,data2,...,datan assuming you are trying to be compatible with

[GENERAL] around fields with psql

2012-02-10 Thread Steve Clark
Hello, Is there a way with psql to get column output to be data1,data2,...,datan I tried -F , but that left off the first and last quote. I can't seem to find a way in the man page. Thanks, -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email:

Re: [GENERAL] around fields with psql

2012-02-10 Thread Scott Marlowe
On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark scl...@netwolves.com wrote: Hello, Is there a way with psql to get column output to be data1,data2,...,datan I tried -F , but that left off the first and last quote. I can't seem to find a way in the man page. Well, you can do it yourself

Re: [GENERAL] around fields with psql

2012-02-10 Thread Steve Clark
On 02/10/2012 02:12 PM, Scott Marlowe wrote: On Fri, Feb 10, 2012 at 11:26 AM, Steve Clarkscl...@netwolves.com wrote: Hello, Is there a way with psql to get column output to be data1,data2,...,datan I tried -F , but that left off the first and last quote. I can't seem to find a way in the

Re: [GENERAL] around fields with psql

2012-02-10 Thread Merlin Moncure
On Fri, Feb 10, 2012 at 1:33 PM, Steve Clark scl...@netwolves.com wrote: On 02/10/2012 02:12 PM, Scott Marlowe wrote: On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark scl...@netwolves.com wrote: Hello, Is there a way with psql to get column output to be data1,data2,...,datan I tried -F ,