Re: Plan for CSV handling of quotes, NULL

Bruce Momjian wrote:

>Andrew Dunstan wrote:
>
>
>>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.
>>
>>
>
>OK, I will start coding.  So FORCE col1, col2 will force quotes on those
>two columns, right?
>
>
>

That's what I was thinking. You would just have it as an array of
booleans indexed by attnum-1 and use it as part of the expression that
sets force_quote.

cheers

andrew