Re: logical column ordering

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: logical column ordering
Date: 2015-02-28 05:25:46
Message-ID: 54F1515A.3000908@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-02-28 05:27:50 Re: Providing catalog view to pg_hba.conf file - Patch submission
Previous Message Pavel Stehule 2015-02-28 05:25:17 Re: Providing catalog view to pg_hba.conf file - Patch submission