469,934 Members | 1,483 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

pg_dump and schema namespace notes

I think this is a suggestion/comment!

pg_dump man page:

--schema-only
Dump only the schema (data definitions), no data

I think this use of the word schema is confusing, meaning data
definitions, whereas elsewhere in the man page schema are used as a
namespace definition.

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

It would be nice if this could be a comman separated list (like set
search_path; A,info,public etc).

Rory
--
Rory Campbell-Lange
<ro**@campbell-lange.net>
<www.campbell-lange.net>

---------------------------(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 23 '05 #1
6 1812

Any comments on this? It seems like a valid confusion. What solutions
are there?

---------------------------------------------------------------------------

Rory Campbell-Lange wrote:
I think this is a suggestion/comment!

pg_dump man page:

--schema-only
Dump only the schema (data definitions), no data

I think this use of the word schema is confusing, meaning data
definitions, whereas elsewhere in the man page schema are used as a
namespace definition.

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

It would be nice if this could be a comman separated list (like set
search_path; A,info,public etc).

Rory
--
Rory Campbell-Lange
<ro**@campbell-lange.net>
<www.campbell-lange.net>

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


--
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 5: Have you checked our extensive FAQ?

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

Nov 23 '05 #2

Any comments on this? It seems like a valid confusion. What solutions
are there?

---------------------------------------------------------------------------

Rory Campbell-Lange wrote:
I think this is a suggestion/comment!

pg_dump man page:

--schema-only
Dump only the schema (data definitions), no data

I think this use of the word schema is confusing, meaning data
definitions, whereas elsewhere in the man page schema are used as a
namespace definition.

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

It would be nice if this could be a comman separated list (like set
search_path; A,info,public etc).

Rory
--
Rory Campbell-Lange
<ro**@campbell-lange.net>
<www.campbell-lange.net>

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


--
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 5: Have you checked our extensive FAQ?

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

Nov 23 '05 #3
Bruce Momjian wrote:
Any comments on this? It seems like a valid confusion. What solutions
are there?

A common interchangeable title for schema is namespace and in actuality
we use \dn in psql (\dnamespace)
to list them.

Perhaps we should change the name? I believe Oracle uses the term
namespace as well.

Sincerely,

Joshua D. Drake

---------------------------------------------------------------------------

Rory Campbell-Lange wrote:

I think this is a suggestion/comment!

pg_dump man page:

--schema-only
Dump only the schema (data definitions), no data

I think this use of the word schema is confusing, meaning data
definitions, whereas elsewhere in the man page schema are used as a
namespace definition.

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

It would be nice if this could be a comman separated list (like set
search_path; A,info,public etc).

Rory
--
Rory Campbell-Lange
<ro**@campbell-lange.net>
<www.campbell-lange.net>

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


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Nov 23 '05 #4
Bruce Momjian wrote:
Any comments on this? It seems like a valid confusion. What solutions
are there?

A common interchangeable title for schema is namespace and in actuality
we use \dn in psql (\dnamespace)
to list them.

Perhaps we should change the name? I believe Oracle uses the term
namespace as well.

Sincerely,

Joshua D. Drake

---------------------------------------------------------------------------

Rory Campbell-Lange wrote:

I think this is a suggestion/comment!

pg_dump man page:

--schema-only
Dump only the schema (data definitions), no data

I think this use of the word schema is confusing, meaning data
definitions, whereas elsewhere in the man page schema are used as a
namespace definition.

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

It would be nice if this could be a comman separated list (like set
search_path; A,info,public etc).

Rory
--
Rory Campbell-Lange
<ro**@campbell-lange.net>
<www.campbell-lange.net>

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


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Nov 23 '05 #5
Bruce Momjian <pg***@candle.pha.pa.us> writes:
Any comments on this? It seems like a valid confusion. What solutions
are there?


I think we're stuck. We can't avoid the fact that the SQL syntax uses
the keyword SCHEMA to mean a namespace. We also can't avoid the very
common usage of "database schema" to mean the logical structure of your
table collection. Trying to redefine or avoid either of these terms is
hopeless. Maybe we could add some text in the tutorial to point out
the double meaning?

regards, tom lane

---------------------------(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 23 '05 #6
Bruce Momjian <pg***@candle.pha.pa.us> writes:
Any comments on this? It seems like a valid confusion. What solutions
are there?


I think we're stuck. We can't avoid the fact that the SQL syntax uses
the keyword SCHEMA to mean a namespace. We also can't avoid the very
common usage of "database schema" to mean the logical structure of your
table collection. Trying to redefine or avoid either of these terms is
hopeless. Maybe we could add some text in the tutorial to point out
the double meaning?

regards, tom lane

---------------------------(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 23 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Patrick Hatcher | last post: by
1 post views Thread by Neil Zanella | last post: by
4 posts views Thread by Glen Parker | last post: by
reply views Thread by aktivo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.