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 Wed, 8 Aug 2007, Emi Lu wrote: > Is there a way that I can only dump all objects under a specific schema? > This questions has nothing to do with Java or JDBC, so cross posting it to this list is inappropriate. Please only send Java related questions here. Kris Jurka
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