Re: Dump produces file with new line characters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dump produces file with new line characters
Дата
Msg-id 5212.1088022364@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Dump produces file with new line characters  ("Mark Spruill" <mark.spruill@mightyautoparts.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Mark Spruill"
Дата:
Сообщение: Dump produces file with new line characters
Следующее
От: "Mark Spruill"
Дата:
Сообщение: Re: Dump produces file with new line characters