Re: why use SCHEMA? any real-world examples?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: why use SCHEMA? any real-world examples?
Date: 2004-11-25 16:57:26
Message-ID: 87d5y127ex.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-11-25 17:11:12 Re: Using IN with subselect
Previous Message Dave Smith 2004-11-25 16:49:06 Using IN with subselect