Dump produces file with new line characters

Поиск
Список
Период
Сортировка
От Mark Spruill
Тема Dump produces file with new line characters
Дата
Msg-id D15742B46C848A49A3C085D96EA5EC91011BA584@firebird.mightyautoparts.com
обсуждение исходный текст
Ответы Re: Dump produces file with new line characters
Список pgsql-general

This is probably a newbie question but here goes:

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 causes
aproblem when I try to load them back in bacause psql thinks the \N (a new line character?) is a psql command.  So, how
doI avoid the \N in the dump and/or ignore it in the reload? 

Any help would be much appreciated.

Mark Spruill

770.448.3900
mark.spruill@mightyautoparts.com


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

Предыдущее
От: Simon Windsor
Дата:
Сообщение: Re: coalesce and nvl question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dump produces file with new line characters