From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200301081726.h08HQmR01291@candle.pha.pa.us>
Subject: Re: What benefits can I expect from schemas ?
In-Reply-To: <200301081655.3939@th00.opsion.fr>
To: Bob Lapique <lapique@ifrance.com>
Date: Wed, 8 Jan 2003 12:26:48 -0500 (EST)
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Bob Lapique wrote:
> Hi,
> 
> I could not find much documentation about SQL 92 schemas that version
> 7.3 now supports. I understood it was a structure to group various
> objects, which allows faster privilege management, namespaces
> definition.
> Besides that, I don't see any advantages. I'd be glad if someone could
> point them out for me, or give doc links.

That's pretty much it.  You can give each user their own namespace so
they can all create tables with the same name, or put applications in
their own namespace so they don't conflict with other applications. 
You can also control object creation easier by restricting privs on the
public namespace.

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