Thread: 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
<rory@campbell-lange.net>
<www.campbell-lange.net>
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 > <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 | 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
Bruce Momjian wrote:
to list them.
Perhaps we should change the name? I believe Oracle uses the term namespace as well.
Sincerely,
Joshua D. Drake
A common interchangeable title for schema is namespace and in actuality we use \dn in psql (\dnamespace)Any comments on this? It seems like a valid confusion. What solutions are there?
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 <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
-- 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
Bruce Momjian <pgman@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