Hello everyone, When I create a table and later on (say, because customers want to store extra info) add a column, like this:
create table test (lastfield varchar); alter table test add column firstfield varchar; is it possible to change the natural order of the columns afterwards? The reason I need this is because the frontend picks up table columns in natural order, looks at the datatype and creates view, input and mutate (html) forms. I'd rather not use views, allthough I know this is "the right way", because it would make the application a lot more complex. Can I dive into some system tables and change the natural order? Thanks! ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
