Postgres Pro
Downloads
Home   >   mailing lists

pg_dump: Exporting SQL and data for a schema ONLY?? - Mailing list pgsql-novice

From Brian Huber
Subject pg_dump: Exporting SQL and data for a schema ONLY??
Date
Msg-id 20031112014042.51734.qmail@web10205.mail.yahoo.com
Whole thread Raw
Responses Re: pg_dump: Exporting SQL and data for a schema ONLY??
List pgsql-novice
Tree view 
Hello all -

Does anyone know if there is a way to export a schema
only using pg_dump (or otherwise)?

For example, if I have a database "test" that contains
three schemas "public", "schema1", and "schema2" - and
I want to export the SQL to re-create the tables and
the data for schema1 only - how would I do that?  If I
dump the test database, the schemas are mixed together
and is very cumbersome to extract out just one.

Any suggestions appreciated. Thanks...

BGH

pgsql-novice by date:

Previous
From: Godshall Michael
Date:
Subject: Stored Procedure/Return Rowset/Crystal
Next
From: Tom Lane
Date:
Subject: Re: pg_dump: Exporting SQL and data for a schema ONLY??