Re: postgres 8.2 "end-of-copy marker corrupt" - Mailing list pgsql-novice

On Wed, Mar 28, 2007 at 10:15:35AM -0400, Tom Lane wrote:
> "David Monarchi" <david.e.monarchi@gmail.com> writes:
> > Each line is terminated with a LF (0A), including the last line.  This is
> > the structure that of all of the other files that I can load have.
> > Some of the text fields in the file had \ in them, so I simply replaced all
> > of them with blanks to see if somewhere there was an escape sequence that
> > was causing the problem.
>
> Hm ... AFAICS from looking at the code, it's impossible to get that
> error message unless the file contains \ followed by . followed by
> something that's not either CR or LF.

What is the output of:

grep -c "\\\."

and if that is a "small" number, the output of:

grep -n "\\\."

and

grep "\\\." | hexdump -C