Re: Dump produces file with new line characters - Mailing list pgsql-general

"Mark Spruill" <mark.spruill@mightyautoparts.com> writes:
> We are using Postgres 7.3 on Red Hat 9.  We are doing dumps with a script that does:
> pg_dump  databasename > outfile 2>> logfile
> The resulting dump files occasionally have a  \N at the end of a line of data following the copy command.  This
causesa problem when I try to load them back in bacause psql thinks the \N (a new line character?) is a psql command.
So,how do I avoid the \N in the dump and/or ignore it in the reload? 

This is a new one on me.  Can you show a specific example?

Also, 7.3.what exactly?

            regards, tom lane