Re: [GENERAL] pg_dump and schema namespace notes

[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 <[EMAIL PROTECTED]> <www.campbell-lange.net> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL