469,282 Members | 2,257 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

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)

Nov 12 '05 #1
6 10977

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

Nov 12 '05 #2
"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

Nov 12 '05 #3
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

Nov 12 '05 #4
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

Nov 12 '05 #5
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 | (610) 359-1001
+ 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

Nov 12 '05 #6
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 | (610) 359-1001
+ 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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Robert Jacobson | last post: by
6 posts views Thread by btober | last post: by
reply views Thread by Glenn Davy | last post: by
6 posts views Thread by Rory Campbell-Lange | last post: by
1 post views Thread by raptor | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.