The following bug has been logged online:
Bug reference: 3795
Logged by: Lou Duchez
Email address: lou@paprikash.com
PostgreSQL version: 8.3 beta 3
Operating system: Windows 2003
Description: pg_dump is mis-dumping columns containing line breaks
Details:
Hello,
My copy of PostgreSQL has standard_conforming_strings set to "on", and when
I attempt to pg_dump tables that have strings containing CR/LFs, the data
dumps in a format that psql cannot then reload. The CR/LFs are preceded by
a backslash ("\") in the dump but are not themselves "escaped" -- so instead
of looking like this:
line 1\nline2\nline3
it looks like this:
line 1\
line 2\
line 3
And psql seems to be unable to handle data in that format.