Re: DBs and Schemas

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Adam Ruth <aruth(at)intercation(dot)com>, PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: DBs and Schemas
Date: 2004-01-06 23:44:54
Message-ID: 20040106234454.GA29107@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 06, 2004 at 03:34:21PM -0800, Roderick A. Anderson wrote:
> On Tue, 6 Jan 2004, Oliver Elphick wrote:
>
> > You can use ALTER DATABASE to set that up permanently, without touching
> > the application.
>
> I'd thought of this but since there will be several applications installed
> and some, I am sure, will have same-named tables this could back-fire.

Are you actually going to be doing joins between these applications? If not,
why not setup multiple databases, then you can be sure they won't conflict.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2004-01-06 23:48:28 Re: Paypal WAS: PostgreSQL speakers needed for OSCON
Previous Message Roderick A. Anderson 2004-01-06 23:34:21 Re: DBs and Schemas