Re: Reordering columns in a table

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