Re: [GENERAL] Dump all objects under a specific schema

2007-08-08 Thread Michael Glaesemann
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 gr

Re: [GENERAL] Dump all objects under a specific schema

2007-08-08 Thread Aurynn Shaw
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 -f output.sql Hope that helps, Aurynn Sha

[GENERAL] Dump all objects under a specific schema

2007-08-08 Thread Emi Lu
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! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster