PostgreSQL: move from child table to parent table

Source: Postgres table inheritance: move from parent to child and vice versa

with deleted as (delete from  returning *) insert into  select * from deleted