Postgres Pro
Downloads
Home   >   mailing lists

Re: Change order of table-columns in pg_catalog.pg_attribute.attnum - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Change order of table-columns in pg_catalog.pg_attribute.attnum
Date
Msg-id 20070606143852.GF6377@alvh.no-ip.org
Whole thread Raw
In response to Change order of table-columns in pg_catalog.pg_attribute.attnum  (Erwin Brandstetter <brsaweda@gmail.com>)
Responses Re: Change order of table-columns in pg_catalog.pg_attribute.attnum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Change order of table-columns in pg_catalog.pg_attribute.attnum
Next
From: Tom Lane
Date:
Subject: Re: Change order of table-columns in pg_catalog.pg_attribute.attnum