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

I am certainly open to the wiki idea. Each script has to be customized
so only a description of the steps and samples could be included. How do
I go about adding this to the wiki? Is there someone else that maintains
the wiki that I can contact? Is it something I could write up and turn
over to the wiki maintainer for publishing?

The idea for the script comes from SQL Server Management Studio,
Microsoft Access and, while I haven't used MySQL in quite a while, I
believe it can also handle the insertions of fields in the middle of a
table using the SQL Workbench product. I use it on an almost daily basis
in the work I do. I imagine the benefits for users, once working would
outweigh the complaints that you would receive during development. For
me, the benefits would be that I could apply the time it takes to write
a script towards modifying my clients' products in other ways. Please
reconsider your original reply.

And thank you for the quick response to my initial request.

*/Patrick Headley/*
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com
www.linxco-inc.com
On 05/06/2016 02:48 PM, David G. Johnston wrote:
> On Fri, May 6, 2016 at 12:53 PM, Patrick Headley
> <pheadley(at)linxco-inc(dot)com <mailto:pheadley(at)linxco-inc(dot)com>>wrote:
>
> I would like it if pgAdmin could generate the script to insert
> table columns into the middle of an existing table. This is
> something that is available in the SQL Server Management Studio,
> which uses essentially the same steps that I described in my
> initial request. So, hte answer is neither A or B but to script
> the insertion of columns into an existing table, which requires
> the creation of a replacement table with the new columns.
>
> I've attached one of my scripts to this message. This script is
> pretty complex.
>
> ​
> That qualifies as option A
>
> If it can be done via a script I'd suggest just adding said script to
> our Wiki. I see very little benefit to having this embedded into
> pgAdmin.​
>
> But hey, maybe this is something the pgAdmin4 team would want to consider.
>
> Without native column-reorder support in the database I'm highly
> skeptical of adding something like this into pgAdmin. The complaints
> we're likely to receive by users outweigh the benefit, IMO.
>
> David J.
>