On Thu, 20 Aug 2009 09:21:25 +0000 (GMT), Scara Maccai <m_lists@xxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
