New to PostGIS. I have a few large multipolygon datasets with errors that PostGIS should be able to fix quite efficiently. However, when in QGIS I try to import the layers into PostGIS, it will error out and stop importing when it reaches an invalid geometry.
The data currently is spread among a series of geopackages that load fine in QGIS, but the layers contain many errors. My desire is to use PostGIS to fix the errors. There are too many to manually fix.
How do I get invalid geometry into PostGIS so that I can use the various
ST_ wrappers to fix it?