Gan Uesli Starling <alias(at)starling(dot)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