Re: Change order of table-columns in pg_catalog.pg_attribute.attnum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Change order of table-columns in pg_catalog.pg_attribute.attnum
Date: 2007-06-06 14:38:52
Message-ID: 20070606143852.GF6377@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Erwin Brandstetter escribió:
> Hi group!
>
> If I want to change the default order of two columns of a table, can I
> just manipulate the values in
> pg_catalog.pg_attribute.attnum?

It works -- as long as the table is empty.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-06-06 14:59:19 Re: Change order of table-columns in pg_catalog.pg_attribute.attnum
Previous Message Erwin Brandstetter 2007-06-06 13:59:48 Change order of table-columns in pg_catalog.pg_attribute.attnum