Postgres Pro
Downloads
Home   >   mailing lists

Re: How to add an INHERITS to an already populated table - Mailing list pgsql-general

From Richard Huxton
Subject Re: How to add an INHERITS to an already populated table
Date
Msg-id 429C2BF9.3000403@archonet.com
Whole thread Raw
In response to How to add an INHERITS to an already populated table ?  (David Pradier <dpradier@apartia.fr>)
Responses Re: How to add an INHERITS to an already populated table
List pgsql-general
Tree view 
David Pradier wrote:
> Hi everybody,
>
> is it possible to add some inheritance lively, without doing a
> dump/restore ?

Not AFAIK. Easiest solution is probably to script some ALTER TABLE ADD
COLUMN commands.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: a way to reset the postgres password to nothing..
Next
From: "Zlatko Matic"
Date:
Subject: Re: How to add an INHERITS to an already populated table ?