Altering metadata to add inheritance - Mailing list pgsql-general

From jboes@nexcerpt.com (Jeff Boes)
Subject Altering metadata to add inheritance
Date
Msg-id d40a65a1.0201310912.2bacd597@posting.google.com
Whole thread Raw
Responses Re: Altering metadata to add inheritance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
As an experiement, I want to turn a number of identically structured
tables into "child" tables of a template.  That is, I want to do
something like:

alter table foo_01 rename to foo_01_old;
create table foo_01 () inherits (foo_template);
insert into foo_01 select * from foo_01_old;
drop table foo_01_old;

a whole lotta times, for different values of 'foo_01'.  I suspect
there's a way to do this directly in the pg_class table.  Does anyone
have a tried and safe approach?

pgsql-general by date:

Previous
From: Jim Martinez
Date:
Subject: Re: Function to Pivot data
Next
From: Tom Lane
Date:
Subject: Re: process exited with status 11 after XLogFlush: request is not satisfied