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

From Bruce Momjian
Subject Re: dump schema schema only?
Date
Msg-id 200310301623.h9UGNvp07463@candle.pha.pa.us
Whole thread Raw
In response to Re: dump schema schema only?  (Harald Fuchs <nospam@sap.com>)
List pgsql-general
Harald Fuchs wrote:
> 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?

Really?  Perhaps we haven't updated the manual pages, but the SGML is
OK.  I have added this to the list to be done before 7.4 final.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: slow query performance
Next
From: Robert Treat
Date:
Subject: Re: Sending email from PL/pgsql