Re: Schema overlay question

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Schema overlay question
Date: 2005-09-02 22:05:22
Message-ID: 20050902220522.GA29223@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey E. Koposov 2005-09-02 22:53:22 Re: operators, operator classes, Btree and index usage
Previous Message Douglas McNaught 2005-09-02 21:57:18 Re: Schema overlay question