Reordering columns in a table

From: John McCawley <nospam(at)hardgeus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reordering columns in a table
Date: 2006-01-06 15:45:53
Message-ID: 43BE90B1.7010008@hardgeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Is there a way to change the order of columns in a table in Postgres
after it has been created? Back when I used MS SQL Server, it was
trivial to go into Enterprise Manager and move columns up and down. I
find this a desirable feature, as I like to keep like columns grouped in
my table. Sometimes I add a column after table creation that makes more
sense grouped with columns toward the top of the table.

John

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joshua D. Drake 2006-01-06 15:55:36 Re: Reordering columns in a table
Previous Message Tom Lane 2006-01-06 15:31:36 Re: Problems building pg 8.1.1

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2006-01-06 15:50:29 Re: Adding another primary key to a populated table
Previous Message Reid Thompson 2006-01-06 15:44:14 Re: 'Official' definition of ACID compliance?