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? 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

No. You could use a view on the table for presentation purposes.

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/