Nabil Sayegh <postgresql@e-trolley.de> writes:
> I need to merge 2 versions of a database manually via pg_dump.
> I'd like to diff them to see the changes.
> Unfortunately the data contain newlines.
> Is it possible to quote them, so that each row will be only 1 row in the
> dumps ?
> \n or something like that
What PG version are you using?? All recent releases *do* dump newline
as \n, for example
COPY fooey (f1) FROM stdin;
hi
hi\nthere
ho
\.
regards, tom lane