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.

Reply via email to