On Jan 19, 2007, at 11:03 AM, johnf wrote:
> From what I understand the use schema is to separate users use of
> tables. IOW
> just added security. But like I said I have never used schemas -
> but a
> public one. So please add to the discussion.
The most common use for schemas that I have seen is to logically
compartmentalize data. Example: keeping a separate schema for each
fiscal year, making it easy to work with years individually, or
occasionally to select across years. Likewise for a company that has
several divisions; each division gets its own schema, so that they
can work independently, but queries can be run by the main office
that combine schemas.
I don't quite get why schemas are necessary; I don't understand why
you can't just use separate databases.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
