I have a table "company" and another named "school" ("school" table inherits "company"). Most of the data is community generated and sometimes a cleaning is needed. I would like to be able to "transfer" a row from the company table to the school table without modifying its ID (because there could be some foreign keys linked to it).
Is there a clean way to do this ?
Thanks for your help.