From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Schema Questions |
Date: | 2006-02-23 17:06:58 |
Message-ID: | 20060223170658.68526.qmail@web33315.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi all,
i just read the pgsql manual schema section
http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html
and i have a couple questions.
1. the first reason listed for using schemas is...
"To allow many users to use one database without
interfering with each other."
i don't quite understand this statement. does this
assume that users will be divided between schemas,
thereby reducing the load on a given schema? i'd
appreciate it if someone could clarify what is meant
here.
2. would using schemas be a good approach to separate
out public data from private data? for example, does
it make sense to create a schema for private data and
another for public data (with a different user)?
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2006-02-23 17:11:43 | Re: Schema Questions |
Previous Message | Kevin Crenshaw | 2006-02-23 16:18:15 | Re: SQL Question |