Re: Column Ordering

--- Sean Davis <sdavis2@mail.nih.gov> wrote:
> > I want to add another column by altering the table at 2nd position
> > Is there anyway to do so.
>
> No.  However, you could create a view with the column ordering you want,
> after adding the new column.

This feature is on the to-do list.  But there isn't any ETA for when we should expect it.  I am
pretty sure it isn't included in version 8.3.

So I guess that this feature could be expected over the next couple of years in versions 8.4 or
8.5(9.0?).

http://www.postgresql.org/docs/faqs.TODO.html#section_8

See bullet:  "Alter" and sub-bullet: "Allow column display reordering ..."

Regards,
Richard Broersma Jr.