add column specify position - Mailing list pgsql-general

Hi all,

Is it possible to specify a position when adding a column to a table?

I want to swap one column for another without losing the column's
position.  eg:  given that 'foo' is the 5th column in an 8 column
table, I want to replace it with a 'bar' column at column 5.

    ALTER TABLE qwe DROP COLUMN foo;
    ALTER TABLE qwe ADD COLUMN bar;


I'm writing a sql script to migrate from one version of my schema to
another, dropping one column and adding another to a number of
tables.  Unfortunately, the windowing toolkit I'm using relies on
integer values to determine column positions.

Any ideas come to mind?

Thanks in advance!
Scott