Re: dump schema schema only?

From: Harald Fuchs <nospam(at)sap(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dump schema schema only?
Date: 2003-10-30 13:21:28
Message-ID: pu65i6zwrr.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <20051(dot)1067459901(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> "Patrick Hatcher" <PHatcher(at)macys(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Weaver 2003-10-30 13:49:46 Re: slow query performance
Previous Message Jeff 2003-10-30 13:20:05 Re: slow query performance