pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat benefits can I expect from schemas ?
4+ messages / 3 participants
[nested] [flat]
* What benefits can I expect from schemas ?
@ 2003-01-08 16:55 Bob Lapique <lapique@ifrance.com>
2003-01-08 17:26 ` Re: What benefits can I expect from schemas ? Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Bob Lapique @ 2003-01-08 16:55 UTC (permalink / raw)
To: pgsql-sql
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.
Thanks.
_____________________________________________________________________
GRAND JEU SMS : Pour gagner un NOKIA 7650, envoyez le mot IF au 61321
(prix d'un SMS + 0.35 euro). Un SMS vous dira si vous avez gagné.
Règlement : http://www.ifrance.com/_reloc/sign.sms
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What benefits can I expect from schemas ?
2003-01-08 16:55 What benefits can I expect from schemas ? Bob Lapique <lapique@ifrance.com>
@ 2003-01-08 17:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-09 02:20 ` Re: What benefits can I expect from schemas ? chester c young <chestercyoung@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2003-01-08 17:26 UTC (permalink / raw)
To: Bob Lapique <lapique@ifrance.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What benefits can I expect from schemas ?
2003-01-08 16:55 What benefits can I expect from schemas ? Bob Lapique <lapique@ifrance.com>
2003-01-08 17:26 ` Re: What benefits can I expect from schemas ? Bruce Momjian <pgman@candle.pha.pa.us>
@ 2003-01-09 02:20 ` chester c young <chestercyoung@yahoo.com>
2003-01-09 02:26 ` Re: What benefits can I expect from schemas ? Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: chester c young @ 2003-01-09 02:20 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql
> > I could not find much documentation about SQL 92 schemas that
> > 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.
Can you copy by schema?
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What benefits can I expect from schemas ?
2003-01-08 16:55 What benefits can I expect from schemas ? Bob Lapique <lapique@ifrance.com>
2003-01-08 17:26 ` Re: What benefits can I expect from schemas ? Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-09 02:20 ` Re: What benefits can I expect from schemas ? chester c young <chestercyoung@yahoo.com>
@ 2003-01-09 02:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2003-01-09 02:26 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
chester c young wrote:
> > > I could not find much documentation about SQL 92 schemas that
> > > 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.
>
> Can you copy by schema?
No.
--
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-01-09 02:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-08 16:55 What benefits can I expect from schemas ? Bob Lapique <lapique@ifrance.com>
2003-01-08 17:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-01-09 02:20 ` chester c young <chestercyoung@yahoo.com>
2003-01-09 02:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
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