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@postgresql.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/