Re: R: Field's position in Table

On Thu, 20 Aug 2009 09:21:25 +0000 (GMT), Scara Maccai <m_lists(at)yahoo(dot)it>
wrote:
>> When adding a new field in the existing table, i
>> want to add the filed in a particular position.
>
> I'm afraid the only way would be re-writing the whole table (pseudo
sql):
>
> BEGIN;
> create table newtable as select field1, 'newfield default value', field2
> from old_table;
> create_all_indexes on newtable;
> drop old_table;
> commit;
>
> things get complicated if you have foreign keys pointing to old_table...

Which is why you might be better off putting the new field at the end of
the table
and using an administrative view to make your viewing easier.

I can't really think of any real reason to put the field at a particular
position, applications
don't reallty care about the order of fields.