Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?

Brice Ruth <brice@webprojkt.com> writes:
> Here's my latest tactic: I'm guessing that the data 'corruption' has
> something to do with the way the data was exported from the original
> database by the third party ... probably something with the cr/lf
> linebreaks or something to that effect (the data field in question
> happens to be the last field in a line in the data file).

Ooooh ... the queries you were showing us made it look like the column
was not the last one, so I hadn't thought of that.  Almost certainly,
your extra character is a CR.  Postgres expects plain LF as newline in
COPY data files; if the newlines are actually CR/LF then the CRs will
be taken as part of the last data field.

            regards, tom lane