Search Postgresql Archives

Putting restrictions on pg_dump?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux