Make shp2pgsql -s : work with -D

[robe]

Right now the -s <some srid>:<to other srid> doesn't work with -D option.

This is because it uses INSERT commands with a ST_Transform.

So I usually end up not using it because it's slower than using -D + ALTER … table change the projection.

What I was thinking is why don't we just have the shp2pgsql command do that — do the ALTER right after if the user chooses to use -D.

The other alternative is to build real proj support into shp2pgsql, but I'd much rather not do that because then we might run into issues with the client computer using shp2pgsql having different install from the server and also wouldn't take care of cases where user manually installs their own entries in the server.

[robe]

In 17621:

Support for srid reprojection when using -D switch
References #4403
Tests forthcoming

[robe]

In 17622:

Get rid of trailing spaces
References #4403

[robe]

In 17623:

Hoepfully last trailing space
References #4403

[robe]

In 17624:

Add regression tests for using -s from_srid:to_srid with -D (copy mode) for both geometry and geography
Closes #4403