Skip site navigation (1) Skip section navigation (2)

Re: dump schema schema only?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: hf99(at)protecting(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump schema schema only?
Date: 2003-10-30 16:23:57
Message-ID: 200310301623.h9UGNvp07463@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Harald Fuchs wrote:
> 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?

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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-general by date

Next:From: Rick GiggerDate: 2003-10-30 16:38:44
Subject: Re: Transaction Performance Question
Previous:From: Robert TreatDate: 2003-10-30 16:20:27
Subject: Re: Sending email from PL/pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group