From: Hepworth, Mike <mike.hepworth@pbs.proquest.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: SCHEMA's
Date: Mon, 3 Mar 2003 18:30:40 -0700
Message-ID: <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com> (raw)
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.....
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: mike.hepworth@pbs.proquest.com
Subject: Re: SCHEMA's
In-Reply-To: <BA4D671159071C49929FCB5CCCDB9D070144C4@sl2exc1.sl2server.power.bellhow.com>
* 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