Thread: Function COPY

Function COPY

From
"DaviS Quirico"
Date:
Hi,
I use postgresql 7.0.3 in redhat 6.2.
I installed .rpm binary and work good.
But i find a problem during import text file
Using the function copy from a text file (about 250Mb of size) i can see
this error:

CopyReadAttribute: end of record marker corrupted

So, i can't import my data.

I try using small file, nothing to do..

I try with the "original" 6.5.3 in bundle with RH 6.2 and i get the same
result...

Any ideas?

Thanks.

Re: Function COPY

From
Tom Lane
Date:
"DaviS Quirico" <davis@davisnet.it> writes:
> CopyReadAttribute: end of record marker corrupted

This message comes out if the COPY data contains \. not immediately
followed by newline (\n).  I'm guessing that you have some backslashes
that need to be doubled --- backslash is an escape character for COPY.

Another possibility is that you actually did put a \. end-marker after
your data, but followed it with a DOS-style return (\r\n) or nothing at
all.

            regards, tom lane