Thread: Dump all objects under a specific schema
Hello List, Is there a way that I can only dump all objects under a specific schema? I'd like to dump all tables, views' definition and data under a specific schema. Thank you!
Hi; > Hello List, > > Is there a way that I can only dump all objects under a specific > schema? > > I'd like to dump all tables, views' definition and data under a > specific schema. > pg_dump --help says that you're looking for the -n flag, so, pg_dump -n <your_schema> -f output.sql Hope that helps, Aurynn Shaw The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103 PostgreSQL Replication, Consulting, Custom Development, 24x7 support ashaw@commandprompt.com
On Aug 8, 2007, at 14:18 , Emi Lu wrote: > Is there a way that I can only dump all objects under a specific > schema? Have you checked the pg_dump documentation? http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html In particular, the -n flag might interest you. Michael Glaesemann grzm seespotcode net