John R Pierce wrote:
>> I would really like postgres to model the alter syntax of mysql,
>> which is really easy to modify table schema especially to include the
>> AFTER col_name part.
>
>
> A) why does the order of the columns in a particular table matter at all?
If coding without caring (about portability/robustness), unfortunately
programmers are seduced by MySQL to work like that..
>
> B) is this any sort of SQL standard?
Definitely no.
Do not use SELECT * if you need a specific column ordering, *that* is
SQL standard.
Regards,
Andreas