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.

On Fri, May 6, 2016 at 12:53 PM, Patrick Headley <pheadley@linxco-inc.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.