Re: logical column ordering - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: logical column ordering
Date
Msg-id 54F1515A.3000908@BlueTreble.com
Whole thread Raw
In response to Re: logical column ordering  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: logical column ordering  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 2/27/15 2:37 PM, Gavin Flower wrote:
> Might be an idea to allow lists of columns and their starting position.
>
> ALTER TABLE customer ALTER COLUMN (job_id, type_id, account_num) SET
> ORDER 3;

I would certainly want something along those lines because it would be 
*way* less verbose (and presumably a lot faster) than a slew of ALTER 
TABLE statements.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Providing catalog view to pg_hba.conf file - Patch submission
Next
From: Stephen Frost
Date:
Subject: Re: Proposal: knowing detail of config files via SQL