pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSCHEMA's
2+ messages / 2 participants
[nested] [flat]
* SCHEMA's
@ 2003-03-04 01:30 Hepworth, Mike <mike.hepworth@pbs.proquest.com>
0 siblings, 1 reply; 2+ messages in thread
From: Hepworth, Mike @ 2003-03-04 01:30 UTC (permalink / raw)
To: 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.....
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SCHEMA's
@ 2003-03-04 02:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: Hepworth, Mike <mike.hepworth@pbs.proquest.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-03-04 02:25 UTC (permalink / raw)
To: Hepworth, Mike <mike.hepworth@pbs.proquest.com>; +Cc: pgsql-sql
"Hepworth, Mike" <mike.hepworth@pbs.proquest.com> writes:
> I want to be able make a user have a default schema other than public.
If the schema name is the same as the user name then this happens
automatically.
Otherwise, you want to set a search_path value for the user --- see
ALTER USER and read up on the search_path runtime parameter.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-03-04 02:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-04 01:30 SCHEMA's Hepworth, Mike <mike.hepworth@pbs.proquest.com>
2003-03-04 02:25 ` Tom Lane <tgl@sss.pgh.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