Putting restrictions on pg_dump?

Поиск
Список
Период
Сортировка
От Benjamin Smith
Тема Putting restrictions on pg_dump?
Дата
Msg-id 200601042100.26037.lists@benjamindsmith.com
обсуждение исходный текст
Ответы Re: Putting restrictions on pg_dump?  (Klint Gore <kg@kgb.une.edu.au>)
Список pgsql-general
Is there a way to put a limit on pg_dump, so that it doesn't dump ALL data,
but that matching a particular query?

Something like:

pg_dump -da --attribute-inserts -t "customers" \
--matching-query="select * from customers where id=11";

I'd like to selectively dump information from a query, but using the output
format from pg_dump so that it can be used to create a (partial) database.

Can this sort of thing be done?

-Ben
--
"The best way to predict the future is to invent it."
- XEROX PARC slogan, circa 1978

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

Предыдущее
От: Benjamin Smith
Дата:
Сообщение: Re: Anyone doing a 8.1.0-ia64-RHEL4-as.rpm ?
Следующее
От: Pandurangan R S
Дата:
Сообщение: Re: plpgsql question