Re: " " around fields with psql

From: Steve Clark <sclark(at)netwolves(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: " " around fields with psql
Date: 2012-02-10 19:33:05
Message-ID: 4F3570F1.3090903@netwolves.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/10/2012 02:12 PM, Scott Marlowe wrote:
> On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark<sclark(at)netwolves(dot)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(dot)clark(at)netwolves(dot)com
http://www.netwolves.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-02-10 19:54:27 Re: [GENERAL] pg_dump -s dumps data?!
Previous Message David Johnston 2012-02-10 19:19:36 Re: Strategy for Primary Key Generation When Populating Table