shp2pgsql -W "latin1" theshape.shp > thesql.sql
My console responds with:
Shapefile type: PolygonZ Postgis type: MULTIPOLYGON
Note the shapefile type is
PolygonZ. The result is, I have to manually edit the
thesql.sql file and wrap the geometry column in
ST_Force_2D() before executing the SQL, otherwise, Postgres complains I'm trying to import a 3D shape into a 2D column.
How can I force dimensionality to 2 with
Alternatively, can I force it in QGIS?