Re: Adding Column in Specific Position of table - Mailing list pgsql-admin

From Jan Lentfer
Subject Re: Adding Column in Specific Position of table
Date
Msg-id 8BEDDDB7-AE65-41D4-B778-9C4156564322@web.de
Whole thread Raw
In response to Adding Column in Specific Position of table  (Ankur Kaushik <ankurkaushik@gmail.com>)
List pgsql-admin
None that I am aware of. But from my experience, order does not really matter.

Von meinem iPad gesendet

Am 29.04.2015 um 11:53 schrieb Ankur Kaushik <ankurkaushik@gmail.com>:


So Any Other way Apart from Recreating the table structure ?

On Wed, Apr 29, 2015 at 3:21 PM, Jan Lentfer <Jan.Lentfer@web.de> wrote:
Hi, this is not currently possibly with just an ALTER TABLE. Regards, Jan.

Von meinem iPad gesendet

> Am 29.04.2015 um 11:43 schrieb Ankur Kaushik <ankurkaushik@gmail.com>:
>
>
> Hi ,
>
> I can I alter table to add column at specific position ,
>
> below
>
> Table : Post
>
>
> Column : a
>               b
>               d
>
> Want to add new column c before d or after b.

pgsql-admin by date:

Previous
From: Jan Lentfer
Date:
Subject: Re: Adding Column in Specific Position of table
Next
From: Craig James
Date:
Subject: Re: Adding Column in Specific Position of table