Thread: Moving existing tables into an inheritence hierarchy

Good Day:

I have a couple hundred tables t1,t2,...tN that I are free standing. I would like to make them members of a partitioned table t, via inheritence. All the tables have the same layout/format. The method that I am currently using is as follows:

create table x1(check(part=1)) inherits(t);
insert into x1 select * from t1;
drop table t1;
alter table x1 rename to t1;

It works fine, except that it is quite slow. Is there a way of just updating "pg_inherits" and some other table such that postgres is happy without actually doing the inserts?

Thanks.