Tom Lane wrote:
>Bruno Wolff III <bruno@wolff.to> writes:
>
>
>>On Mon, Apr 12, 2004 at 02:26:14 -0400,
>> Andrew Dunstan <andrew@dunslane.net> wrote:
>>
>>
>>>a few points:
>>>. in CSV mode, NULL should default to '' - that was in what I sent in.
>>>
>>>
>
>
>
>>Postgres normally treats an empty string as an empty string. Are you sure
>>you really want it to be treated as a NULL by default in this one place?
>>
>>
>
>I think that's a spectacularly bad idea too. People who really want
>that can write "NULL ''", but it shouldn't be implied by CSV mode.
>
>
>
Spectacularly? Hmm.
My approach was that the default should be the most common case. Perhaps
on import it's a tossup, but on export a CSV containing lots of \N cells
is likely to be ... unexpected.
But, honestly, it's not worth dying in a ditch over.
cheers
andrew