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