pg_dump and schema namespace notes

[Rory Campbell-Lange]

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]

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 | [phone]
+ 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

[Bruce Momjian]

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 | [phone]
+ 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

[Joshua D. Drake]

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.
[phone] - [e-mail] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

[Joshua D. Drake]

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.
[phone] - [e-mail] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

[Tom Lane]

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)

[Tom Lane]

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)