> > 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 ?)
Doesn't that in itself promote bad programming? Relying on the order of columns is a bad thing(tm), imo. > 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. > > ... John ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org