id summary reporter owner description type status priority milestone component version resolution keywords cc 4403 Make shp2pgsql -s : work with -D robe robe "Right now the -s : 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." enhancement closed medium PostGIS 3.0.0 utils/loader-dumper master fixed