Dump a database excluding one table DATA?

Поиск
Список
Период
Сортировка
От Dmitry Koterov
Тема Dump a database excluding one table DATA?
Дата
Msg-id CA+CZih4cWaYN8=7-Mifp1jidrWMT+t3KHFT-X6dft7Kb1nf5Tg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dump a database excluding one table DATA?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Dump a database excluding one table DATA?  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-general
Hello.

Is there any way (or hack) to dump the whole database, but to exclude the DATA from a table within this dump? (DDL of the table should not be excluded: after restoring the data the excluded table should look "empty".)

I see -T switch of pg_dump, but seems -T excludes the data AND the DDL of a table (and possibly all objects which depend on this table?), so after restoration the database structure becomes broken sometimes.

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

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: Using Postgresql as application server
Следующее
От: John Cheng
Дата:
Сообщение: Re: call initdb as regular user