Re: pg_dump --comment?

Поиск
Список
Период
Сортировка
От Chris Campbell
Тема Re: pg_dump --comment?
Дата
Msg-id 40BBBC40.3040804@bignerdranch.com
обсуждение исходный текст
Ответ на Re: pg_dump --comment?  (Harald Fuchs <hf517@protecting.net>)
Список pgsql-hackers
Harald Fuchs wrote:

> Why don't you just do
> 
>   ( echo "-- This is my comment"
>     pg_dump whatever
>   ) > dumpfile
> 
> ?

How could I dump using the custom format, and then use "dumpfile" with 
pg_restore to restore the dump? If I just prepend the comment to the 
file, then pg_restore will choke, since the file won't be in the proper 
custom format. I would have to remove the comment before sending the 
file to pg_restore. Is there an easy way to do that? That can be easily 
automated, and not take a huge amount of time given a 4 gig dump file 
that must be modified?

Given those requirements, building a commenting mechanism into the 
custom format would work out very nicely, I think.

Thanks!

- Chris


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

Предыдущее
От: cvk_ind@rediffmail.com (vicky)
Дата:
Сообщение: Embedded SQL - Unable to connect to PostgreSQL Database
Следующее
От: Tom Lane
Дата:
Сообщение: Fast index build vs. PITR