Schema Questions - Mailing list pgsql-novice

From
Subject Schema Questions
Date
Msg-id 20060223170658.68526.qmail@web33315.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Schema Questions
List 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

pgsql-novice by date:

Previous
From: "Kevin Crenshaw"
Date:
Subject: Re: SQL Question
Next
From: Sean Davis
Date:
Subject: Re: Schema Questions