It is really hard to currently alter table schema.
Particularly the order of the table schema.
to move a column position is very hard. worse if your table as references (and which proper tables don't ?)
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.
http://dev.mysql.com/doc/mysql/en/alter-table.html
thanks,
Llewellyn.