Re: Schema overlay question - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Schema overlay question
Date
Msg-id 20050902220522.GA29223@winnie.fuhr.org
Whole thread Raw
In response to Schema overlay question  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
Responses Re: Schema overlay question
List pgsql-general
On Fri, Sep 02, 2005 at 05:28:11PM -0400, Hrishikesh Deshmukh wrote:
> We are designing a database, the database has three major components (each
> component with 4-8 tables)
> two components are ready, is it possible to 'overlay' the third one later?
> or
> Do i have to drop all the components (along with data!!!) and then add the
> third component and then build the entire DB?
> What i am saying is some tables are existing, could i later add a bunch of
> tables at a later date without dropping the entire database?

What exactly do you mean by "overlay"?  As far as the database is
concerned, you can create tables any time you want: today, tomorrow,
or a year from now.  Is there some specific case you're concerned
about?  If so then please elaborate.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Schema overlay question
Next
From: "Sergey E. Koposov"
Date:
Subject: Re: operators, operator classes, Btree and index usage