Re: pg_dump and schema namespace notes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 06:03:35
Message-ID: 20414.1086847415@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-10 07:03:25 Re: Postgresql vs. aggregates
Previous Message Tom Lane 2004-06-10 05:51:43 Re: Postgresql vs. aggregates

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-06-10 06:26:33 Re: [PATCHES] serverlog function (log_destination file)
Previous Message Tom Lane 2004-06-10 05:14:01 Re: [PATCHES] serverlog function (log_destination file)