From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Bob Lapique <lapique@ifrance.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: What benefits can I expect from schemas ?
Date: Wed, 8 Jan 2003 12:26:48 -0500 (EST)
Message-ID: <200301081726.h08HQmR01291@candle.pha.pa.us> (raw)
In-Reply-To: <200301081655.3939@th00.opsion.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, lapique@ifrance.com
Subject: Re: What benefits can I expect from schemas ?
In-Reply-To: <200301081726.h08HQmR01291@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox