Mathieu Arnold <mat@mat.cc> writes:
>> For that matter, what version(s) are you running?
> both have multibyte support, both encoding LATIN9 (france, euro)
> 7.2 on the linux, 7.2.1 on the freebsd
In that case I think the difference is explained by this 7.2.1 patch:
2002-02-12 16:25 tgl
* doc/src/sgml/ref/copy.sgml, src/backend/commands/copy.c: Modify
COPY TO to emit carriage returns and newlines as backslash escapes
(backslash-r, backslash-n) for protection against
newline-conversion munging. In future we will also tweak COPY
FROM, but this part of the change should be backwards-compatible.
Per pghackers discussion. Also, update COPY reference page to
describe the backslash conversions more completely and accurately.
regards, tom lane