Re: pg_dump and schema namespace notes

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>, Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump and schema namespace notes
Date: 2004-06-10 02:54:25
Message-ID: 40C7CD61.7040400@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shanmugasundaram Doraisamy 2004-06-10 03:39:37 Trouble with locking tables - reg.
Previous Message Bruce Momjian 2004-06-10 02:39:32 Re: pg_dump and schema namespace notes

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-06-10 02:59:57 Re: Fully enabling NLS in pg_ctl
Previous Message Bruce Momjian 2004-06-10 02:49:06 Re: [HACKERS] dynamic_library_path on Win32