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.
phead...@linxco-inc.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
<phead...@linxco-inc.com <mailto:phead...@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.
