Re: Please add the ability to add columns into the middle of a table.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Please add the ability to add columns into the middle of a table.
Дата
Msg-id CAKFQuwYfZ9yVH8hs64=jG2-OLy-HjT6XfrE8_fJRFvQkJtRM4g@mail.gmail.com
обсуждение исходный текст
Ответ на Please add the ability to add columns into the middle of a table.  (Patrick Headley <pheadley@linxco-inc.com>)
Ответы Re: Please add the ability to add columns into the middle of a table.  (Patrick Headley <pheadley@linxco-inc.com>)
Re: Please add the ability to add columns into the middle of a table.  (Darren Duncan <darren@darrenduncan.net>)
Список pgadmin-support
Дерево обсуждения
On Fri, May 6, 2016 at 12:18 PM, Patrick Headley <pheadley@linxco-inc.com> wrote:
Having the ability to insert a column in the middle of a table using the PGAdmin 3 UI would be very nice. Benefits include grouping related fields and creating a column list in the natural flow of data entry. Having it automated within the UI would make this piece of DB management so much easier.

What are you asking for here?

A) For pgAdmin to run a complex algorithm to physcially re-order columns by creating a new table?
​B) For PostgreSQL itself to allow for column re-ordering?

The later has been discussed many times, including relatively recently, but hasn't made it into -core (not even sure if patches have been proposed.

​The data entry aspect can be handled quite readily without any interaction with the physical table.  Having pgAdmin or some other application maintain an ordering table that defaults to physical but can be overridden would be a somewhat trivial project compared to what you propose.

David J.​

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

Предыдущее
От: Patrick Headley
Дата:
Сообщение: Please add the ability to add columns into the middle of a table.
Следующее
От: Patrick Headley
Дата:
Сообщение: Re: Please add the ability to add columns into the middle of a table.