Connecting Tech Pros Worldwide Forums | Help | Site Map

pg_dump and schema namespace notes

Rory Campbell-Lange
Guest
 
Posts: n/a
#1: Nov 23 '05
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
<rory@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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly


Bruce Momjian
Guest
 
Posts: n/a
#2: Nov 23 '05

re: pg_dump and schema namespace notes



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

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

Rory Campbell-Lange wrote:[color=blue]
> 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
> <rory@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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>[/color]

--
Bruce Momjian | http://candle.pha.pa.us
pgman@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

Bruce Momjian
Guest
 
Posts: n/a
#3: Nov 23 '05

re: pg_dump and schema namespace notes



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

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

Rory Campbell-Lange wrote:[color=blue]
> 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
> <rory@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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>[/color]

--
Bruce Momjian | http://candle.pha.pa.us
pgman@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

Joshua D. Drake
Guest
 
Posts: n/a
#4: Nov 23 '05

re: pg_dump and schema namespace notes


Bruce Momjian wrote:
[color=blue]
>Any comments on this? It seems like a valid confusion. What solutions
>are there?
>
>[/color]
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

[color=blue]
>---------------------------------------------------------------------------
>
>Rory Campbell-Lange wrote:
>
>[color=green]
>>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
>><rory@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 majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>>
>>[/color]
>
>
>[/color]


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


Joshua D. Drake
Guest
 
Posts: n/a
#5: Nov 23 '05

re: pg_dump and schema namespace notes


Bruce Momjian wrote:
[color=blue]
>Any comments on this? It seems like a valid confusion. What solutions
>are there?
>
>[/color]
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

[color=blue]
>---------------------------------------------------------------------------
>
>Rory Campbell-Lange wrote:
>
>[color=green]
>>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
>><rory@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 majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>>
>>[/color]
>
>
>[/color]


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


Tom Lane
Guest
 
Posts: n/a
#6: Nov 23 '05

re: pg_dump and schema namespace notes


Bruce Momjian <pgman@candle.pha.pa.us> writes:[color=blue]
> Any comments on this? It seems like a valid confusion. What solutions
> are there?[/color]

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

Tom Lane
Guest
 
Posts: n/a
#7: Nov 23 '05

re: pg_dump and schema namespace notes


Bruce Momjian <pgman@candle.pha.pa.us> writes:[color=blue]
> Any comments on this? It seems like a valid confusion. What solutions
> are there?[/color]

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

Closed Thread