By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,835 Members | 2,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,835 IT Pros & Developers. It's quick & easy.

Pg_Dump of schema?

P: n/a
Pg: 7.4.

I thought there was supposed to be switch to allow dumping of schema X from
a database in version 7.4? But I don't see one.
Is it still not possible?

TIA
Patrick Hatcher

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

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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Patrick Hatcher wrote:
Pg: 7.4.

I thought there was supposed to be switch to allow dumping of schema X from
a database in version 7.4? But I don't see one.
Is it still not possible?


pg_dump --schema does not do it?

http://developer.postgresql.org/docs...pp-pgdump.html

Shridhar
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

P: n/a

Sorry maybe I wasn't clear. Maybe I should have use the word sub-schema.
I have a Development server that contains database DB1 with schemas:
Public, Test_1, Test_2, Test_3

I would like to export schema only Test_3 so that I can import this schema
into my Production database DB1

pg_dump --schema only appears to do the entire database and not just a
particular sub-schema

Thanks again

Patrick Hatcher


Shridhar Daithankar
<shridhar_daithanka
r@myrealbox.com> To
Patrick Hatcher <PH******@macys.com>
12/09/2003 01:02 AM cc
pg***********@postgresql.org
Subject
Re: [GENERAL] Pg_Dump of schema?




Patrick Hatcher wrote:
Pg: 7.4.

I thought there was supposed to be switch to allow dumping of schema X from a database in version 7.4? But I don't see one.
Is it still not possible?


pg_dump --schema does not do it?

http://developer.postgresql.org/docs...pp-pgdump.html

Shridhar

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.