Re: \copy command

dario billo  writes:
> \.
> ": can't parse "ne 1, pg_atoi: error in "
> lost synchronization with server, resetting connection

Given the funny formatting of the error message, I'd bet you have a
newline problem.  COPY does not like anything but Unix-style newlines
(\n only); feeding it Windows-style newlines (\r\n) will lead to
failures like the above.

> why "resetting connection"?

Because there is no other way to recover from a COPY error in the
current FE/BE protocol.  (7.4 will improve that situation, but it
will require client-side rewrites to take advantage of the new
protocol...)

			regards, tom lane