Re: " " around fields with psql - Mailing list pgsql-general

From Steve Clark
Subject Re: " " around fields with psql
Date
Msg-id 4F3570F1.3090903@netwolves.com
Whole thread Raw
In response to Re: " " around fields with psql  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: " " around fields with psql
List pgsql-general
On 02/10/2012 02:12 PM, Scott Marlowe wrote:
On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark <sclark@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 kinda like this:

select '""||field1||'", "||field2||'" from sometable where yada.

Ok that will work

Thanks,

--
Stephen Clark
NetWolves
Director of Technology
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
http://www.netwolves.com

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Strategy for Primary Key Generation When Populating Table
Next
From: Vincent Veyron
Date:
Subject: Re: Strategy for Primary Key Generation When Populating Table