Lew wrote:
>> Try eliminating the double quotes in the CSV file. "Wannabe" NULL
>> would then be ,, (consecutive commas)
>> in the CSV. From the docs, you don't even need the "NULL AS"
>> clause in your COPY statement.
Ivan Sergio Borgonovo wrote:
> Exactly what I did because fortunately there weren't too many chances
> of weird stuff in 2000 records (sed -e 's/,""/,/g').
And this worked, right?
> Anyway with NULL AS '' and without it I can't still import NULL
> without pre-processing.
What pre-processing is that?
> I thought it may be missing total support of UTF-8 or if I did
> something wrong or it is actually a "feature".
This clearly has nothing to do with UTF-8, and everything to with comma-comma
representing a NULL and comma-quote-quote-comma representing an empty string.
--
Lew
This post contained two requests for responses.