Re: Dumping database using 8.1 or 7.1

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Dumping database using 8.1 or 7.1
Дата
Msg-id c2d9e70e0608081706k4744213eja6e493910a36c9b9@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dumping database using 8.1 or 7.1  ("Jonathan Vallar" <bamvallar.db@gmail.com>)
Список pgsql-general
>  It was a little hassle though because I have to manually remove "\M" from
> the dump file. This is manageable.
>
>  I am stucked though with one problem
>  psql:si_t2:36: ERROR: missing data for column "remarks"
> CONTEXT: COPY si_t2, line 145: <some data>
>
> Upon checking line 145, there are no weird characters. Upon checking the
> whole dump file, the db dump still containts
>
>
> Sample data:
> "jonathan \"
> " "
>

maybe data was:
"jonathan \N"

and that "\N" means a null value in COPY dialect...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: PostgreSQL on RAM Disk / tmpfs
Следующее
От: "Gabor Siklos"
Дата:
Сообщение: Does DROP TABLE free up disk space immediately?