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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
