Re: merging 2 dumps

Am Fre, 2003-08-01 um 17.01 schrieb Tom Lane:

> > \n or something like that
>
> What PG version are you using??  All recent releases *do* dump newline
> as \n, for example

pg_dump (PostgreSQL) 7.3.3

> COPY fooey (f1) FROM stdin;
> hi
> hi\nthere
> ho
> \.

I always use: pg_dump -D ... (I don't really like COPY)

Is it also possible to have newlines converted when doing
psql -c "SELECT ..."

tfyh
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de