PostgreSQL migrate data from one table to another (which inherits the first one)
You can use this method (assuming both tables have same columns in same order):

with T as (delete from only company where id=? returning *) 
    insert into school select * from T