Re: why use SCHEMA? any real-world examples? - Mailing list pgsql-general

From Greg Stark
Subject Re: why use SCHEMA? any real-world examples?
Date
Msg-id 87d5y127ex.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: why use SCHEMA? any real-world examples?  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
> > Since the manual says HOW, could anyone here who has used schemas take
> > a minute to describe to a newbie like me why you did?   What benefits
> > did they offer you?   Any drawbacks?

I suspect the consumer of this feature for whom it would make the biggest
difference would be shrinkwrapped packages. For example, if you have a
database and want to add on a logging package, a billing package, and a CMS
system and you want to store the data in your existing database so you can
integrate them all closely together, then it would be nice to at least keep
the database tables in separate namespaces.

--
greg

pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Using IN with subselect
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Using IN with subselect