Stephan Doliov <stephan.doliov@gmail.com> writes:
> I'd like to know whether there is any way to control the order of inherited
> columns?
Nope, not at present.
There's a lot of wished-for functionality around separating the
presentation order of table columns from their physical storage order.
If we had that it'd fix your problem too. But right now, those are
tied together and also tied to the columns' catalog identifiers (attno).
People have investigated changing that, but it looks enormously bug-prone
since the existing code doesn't distinguish these concepts.
regards, tom lane