SCHEMA's

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

Responses

Browse pgsql-sql by date

  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