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!