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

From
Subject What's the point of creating a schema?
Date
Msg-id 200509101747.j8AHlqT19187@panix3.panix.com
Whole thread Raw
Responses Re: What's the point of creating a schema?  (Daniel Staal <DStaal@usa.net>)
Re: What's the point of creating a schema?  (Kretschmer Andreas <andreas_kretschmer@despammed.com>)
Re: What's the point of creating a schema?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice




(Sorry for asking so many questions, but I can't find answers in the
documentation.)

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
see that schemas *may* be useful for complicated designs having a few
hundred tables (i.e. one in which name collisions could become a
common problem), but I can't think of any other situation.

Thanks!

kj

pgsql-novice by date:

Previous
From:
Date:
Subject: ...ADD CONSTRAINT "$1"... ?
Next
From: Daniel Staal
Date:
Subject: Re: What's the point of creating a schema?