Re: COPY WITH CSV FORCE QUOTE *

Itagaki Takahiro wrote:
>> Jaime Casanova <jcasanov@systemguards.com.ec> wrote:
>>
>>     
>>> i can find value for FORCE QUOTE * but what's
>>> the use case for FORCE NOT NULL?
>>>       
>
> Oh, sorry. I misread your mail.
> The patch adds * options "FORCE QUOTE" and "FORCE NOT NULL", too.
> Both of * mean all-columns for each options.
>
>   

I still don't understand the use case for FORCE NOT NULL *.

FORCE QUOTE * is relatively benign. In particular, it doesn't affect the 
null-preserving properties of our CSV implementation, since it still 
won't (or shouldn't) quote null values.

FORCE NOT NULL is in any case a fairly blunt instrument - it doesn't 
work for a column of any type that doesn't accept an empty string as 
valid input, such as numeric types.

I note that this patch was (I think) originally submitted without prior 
discussion. That's not following best practice.

cheers

andrew