dump schema schema only?

[Patrick Hatcher]

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 ma*******@postgresql.org)

[Rick Seeger]

You can use -t to specify a table:

% pg_dump -s database -t tablename
-Rick

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.org]On Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: pg***********@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
ma*******@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

"Patrick Hatcher" <PH******@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Harald Fuchs]

In article <20**************@sss.pgh.pa.us>,
Tom Lane <tg*@sss.pgh.pa.us> writes:

"Patrick Hatcher" <PH******@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?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Harald Fuchs <no****@sap.com> writes:

Tom Lane <tg*@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Bruce Momjian]

Harald Fuchs wrote:

In article <20**************@sss.pgh.pa.us>,
Tom Lane <tg*@sss.pgh.pa.us> writes:

"Patrick Hatcher" <PH******@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
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Bruce Momjian]

Tom Lane wrote:

Harald Fuchs <no****@sap.com> writes:

Tom Lane <tg*@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
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org