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.