From: | "Hepworth, Mike" <mike(dot)hepworth(at)pbs(dot)proquest(dot)com> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | SCHEMA's |
Date: | 2003-03-04 01:30:40 |
Message-ID: | BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Need some help with schema's.
I want to be able make a user have a default schema other than public.
I want to be able to have several schema's with the same group of tables
define in each one.
(Example)
schema a (users 1,2,3)
table a
table b
table c
schema b (users 4,5,6)
table a
table b
table c
schema c (users 7,8,9)
table a
table b
table c
When a user logs into the database they will go to there default schema and
not the public schema.
(Example)
User 5 logs in and by default uses a, b, c tables under schema b.
Any ideas?
Thanks,
Mike Hepworth.....
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-04 02:25:40 | Re: SCHEMA's |
Previous Message | Greg Stark | 2003-03-04 01:26:59 | Re: Forcing query to use an index |