Re: dump schema schema only? - Mailing list pgsql-general

From Harald Fuchs
Subject Re: dump schema schema only?
Date
Msg-id pu65i6zwrr.fsf@srv.protecting.net
Whole thread Raw
In response to dump schema schema only?  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: dump schema schema only?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: dump schema schema only?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
In article <20051.1067459901@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:

> "Patrick Hatcher" <PHatcher@macys.com> writes:
>> I have a development server where I, well, do my development. Occasionally,
>> I will create a new schema within an existing database that I would like to
>> use on my production machine.   I know that doing a pg_dump -s <database>
>> > somefile.sql will dump the entire schema of the database, but is there a
>> way to export only schema X from the database?

> 7.4's pg_dump has an option to dump the contents of just one schema.

The pg_dump manpage of beta4 does not include this option, although
the source code does.  Has this been fixed in beta5?

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Sending email from PL/pgsql
Next
From: Jeff
Date:
Subject: Re: slow query performance