Thread: dump schema schema only?

dump schema schema only?

From

"Patrick Hatcher"

Date:

29 October 2003, 17:06:24

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?

TIA
Patrick Hatcher

Re: dump schema schema only?

From

"Rick Seeger"

Date:

29 October 2003, 18:16:45

You can use -t to specify a table:

% pg_dump -s database -t tablename


-Rick



-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] dump schema schema only?


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?

TIA
Patrick Hatcher



---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)

Re: dump schema schema only?

From

Tom Lane

Date:

29 October 2003, 19:39:06

"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.

            regards, tom lane

Re: dump schema schema only?

From

Harald Fuchs

Date:

30 October 2003, 12:20:01

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?

Re: dump schema schema only?

From

Tom Lane

Date:

30 October 2003, 14:47:11

Harald Fuchs <nospam@sap.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> 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,

Sure it does:

-n namespace
--schema=schema

     Dump the contents of schema only. If this option is not specified,
     all non-system schemas in the target database will be dumped.

            regards, tom lane

Re: dump schema schema only?

From

Bruce Momjian

Date:

30 October 2003, 15:30:35

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

Re: dump schema schema only?

From

Bruce Momjian

Date:

30 October 2003, 17:15:27

Tom Lane wrote:
> Harald Fuchs <nospam@sap.com> writes:
> > Tom Lane <tgl@sss.pgh.pa.us> writes:
> >> 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,
>
> Sure it does:
>
> -n namespace
> --schema=schema
>
>      Dump the contents of schema only. If this option is not specified,
>      all non-system schemas in the target database will be dumped.

I thought he was complaining because our 'man' output wasn't updated for
7.4.  I just checked beta5's man.tar.gz, and it has the 7.3 contents,
and doesn't mention -n/--schema.  I have added to our open items list:

    Update manual pages.

--
  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