Re: pg_dump schma while excluding specific table

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Re: pg_dump schma while excluding specific table
Дата
Msg-id 1320345970.24716.YahooMailNeo@web46101.mail.sp1.yahoo.com
обсуждение исходный текст
Ответ на pg_dump schma while excluding specific table  (Tony Capobianco <tcapobianco@prospectiv.com>)
Список pgsql-general
Tony --



> When I issue:
>
> pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> /DUMPDIR/newdb.log
>
> I get a dump of the entire dev schema.  My goal is to dump the dev
> schema minus the corgi table.  How can I adjust my script to perform
> this function?
>
> Thanks.


Maybe the order of your arguments is causing some issues. This worked for me

  pg_dump -s -T product_feed_data staging_feed > sf.sql

Where staging_feed is that database and product_feed_data is the table I excluded:
grep product_feed_data sf.sql | grep -v product_feed_data_
COMMENT ON TABLE product_key IS 'A temporary table used to sync product_feed_data.does_exist_in_product.  ...

HTH,

Greg Williamson

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: FATAL: password authentication failed for user "postgres"
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_dump schma while excluding specific table