Skip site navigation (1) Skip section navigation (2)

Schema Questions

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
hi all,

i just read the pgsql manual schema section

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

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)?


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


pgsql-novice by date

Next:From: Sean DavisDate: 2006-02-23 17:11:43
Subject: Re: Schema Questions
Previous:From: Kevin CrenshawDate: 2006-02-23 16:18:15
Subject: Re: SQL Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group