Re: Adding Column in Specific Position of table

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: Adding Column in Specific Position of table
Дата
Msg-id CAFwQ8rdEJ5-Z6fz4=Wh0e--X64scLGRYGYLpwVi+TK2Rc9cEmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Adding Column in Specific Position of table  (Jan Lentfer <Jan.Lentfer@web.de>)
Список pgsql-admin
On Wed, Apr 29, 2015 at 2:51 AM, 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.

It's probably a bad idea, too. If your application depends on the ordering of the columns, I guarantee you'll regret it. It's a recipe for mysterious bugs.

Every SQL query should name the columns. If you do that, the column ordering doesn't matter.

Craig

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jan Lentfer
Дата:
Сообщение: Re: Adding Column in Specific Position of table
Следующее
От: "Ferrell, Denise CTR NSWCDD, Z11"
Дата:
Сообщение: Graphic Interpretations of Data