Re: Reordering columns in a table

[Berend Tober <btober@xxxxxxxxxxxxxxxx>]

John McCawley wrote:

> Is there a way to change the order of columns in a table in Postgres 
> after it has been created?  ...

The best way to do it is when you have the opportunity to do a restore, 
edit the pg_dump output between the dump and the restore steps. There 
are other approaches that might not be feasible depending on 
circumstances, like dropping and recreating the table and reloading 
data, but you have to deal with foreign key and other dependencies and 
so it is probably more work than justifiable for something that makes no 
practical difference.

Regards,
Berend Tober