pg_dump: Exporting SQL and data for a schema ONLY??

From: Brian Huber <brianghuber(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dump: Exporting SQL and data for a schema ONLY??
Date: 2003-11-12 01:40:42
Message-ID: 20031112014042.51734.qmail@web10205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-11-12 04:29:40 Re: pg_dump: Exporting SQL and data for a schema ONLY??
Previous Message Kieran Clinton Tarestad 2003-11-11 22:18:57 Java client on local machine update database on server