Re: DBs and Schemas - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: DBs and Schemas
Date
Msg-id 20040106234454.GA29107@svana.org
Whole thread Raw
In response to Re: DBs and Schemas  ("Roderick A. Anderson" <raanders@acm.org>)
Responses Re: DBs and Schemas  ("Roderick A. Anderson" <raanders@acm.org>)
List 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@svana.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

Attachment

pgsql-general by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: DBs and Schemas
Next
From: Adam Ruth
Date:
Subject: Re: DBs and Schemas