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.
On 05/06/2016 01:24 PM, David G. Johnston wrote: