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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to