On Tue, 10 May 2011 15:59:07 +0200
Ivan Sergio Borgonovo m...@webthatworks.it wrote:
Sorry for the noise. The csv was automatically generated. The code
was right but during generation there was some problem with the box
generating it (php segfaulting) and there were some unclosed quotes
in a much
I'm on pg 8.3.14
I'm trying to import a csv with
\copy anagraficaclienti from
'myfile.csv'
delimiter as E' ' -- this is a tab \t
null as 'NULL'
csv
header
quote as E''
escape as E'\\'
What I get is
ERROR: unquoted carriage return found in data
HINT: Use quoted CSV
Hello
COPY doesn't like '\n' too.
Replace '\n' by '\\n'
Regards
Pavel Stehule
2011/5/10 Ivan Sergio Borgonovo m...@webthatworks.it:
I'm on pg 8.3.14
I'm trying to import a csv with
\copy anagraficaclienti from
'myfile.csv'
delimiter as E' ' -- this is a tab \t
null as 'NULL'
On Tue, 10 May 2011 14:38:23 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
Hello
COPY doesn't like '\n' too.
Replace '\n' by '\\n'
mmm maybe you were mislead by the semi-transliterated hexdump.
There is no slash in the record, the actual input was the one
reported in hex. The