Re: Adding Column in Specific Position of table

From: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
To: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Adding Column in Specific Position of table
Date: 2015-04-29 09:57:12
Message-ID: 8BEDDDB7-AE65-41D4-B778-9C4156564322@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com>:
>
>
> So Any Other way Apart from Recreating the table structure ?
>
>> On Wed, Apr 29, 2015 at 3:21 PM, Jan Lentfer <Jan(dot)Lentfer(at)web(dot)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(at)gmail(dot)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.
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2015-04-29 15:28:35 Re: Adding Column in Specific Position of table
Previous Message Jan Lentfer 2015-04-29 09:51:58 Re: Adding Column in Specific Position of table