Re: Plan for CSV handling of quotes, NULL - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: Plan for CSV handling of quotes, NULL
Date
Msg-id 4312.24.211.141.25.1082021572.squirrel@www.dunslane.net
Whole thread Raw
In response to Plan for CSV handling of quotes, NULL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Plan for CSV handling of quotes, NULL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian said:
> Andrew Dunstan wrote:
>>
>> copy mytable to 'mydata.csv' csv force zipcode;
>>
>> seems OK to me. I'm all in favor of low-tecH solutions where
>> appropriate. ;-)
>
> Could we have FORCE just force quotes on all values, rather than
> allowing a list of columns to be specified?  Seems if you have a
> strange zipcode field, it would be easier to just do them all.
>

Then dates and numbers would be wrong. No all or nothing switch will work.

cheers

andrew



pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Update french translation of the 7.4 branch
Next
From: Andrew Dunstan
Date:
Subject: Re: Plan for CSV handling of quotes, NULL