Re: Reverting from subtables to no subtables. - Mailing list pgsql-novice

Gan Uesli Starling <alias@starling.us> writes:
> If I DROP the subtable, will I lose all its rows?

Yes.

> How best should I do this?

Something like
    INSERT INTO parent SELECT appropriate-columns FROM ONLY child;

            regards, tom lane