Re: merging 2 dumps

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