Postgres Pro
Downloads
Home   >   mailing lists

Re: What's the point of creating a schema? - Mailing list pgsql-novice

From Kretschmer Andreas
Subject Re: What's the point of creating a schema?
Date
Msg-id 20050910203236.GA3810@kaufbach.delug.de
Whole thread Raw
In response to What's the point of creating a schema?  (<kynn@panix.com>)
List pgsql-novice
Tree view 
kynn@panix.com <kynn@panix.com> schrieb:
> Why would one bother to create a schema (with "create schema blah
> blah")?  Isn't a database enough to keep tables, etc. separate?  I can

For instance:

I have several locations in our company. Now i want to have individual
tables for every location, and a summarized view over all locations.
Thats why i create a schema for every location with individual tables,
and a summarized view over all locations.


Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: ...ADD CONSTRAINT "$1"... ?
Next
From: Oliver Elphick
Date:
Subject: Re: What's the point of creating a schema?