On Thu, 2007-03-15 at 08:35, Shavonne Marietta Wijesinghe wrote: > When i alter a table and add a new column it always adds it to the end > of the table. Is there any way to tell it to add the new column at the > 5th position or to add the new column after a surtain column.
No, but the good news is you can just recreate the table once it's stabilized in form with something like: create table new_table as select field1, field4, field2, field3 from old_table; ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
