[QGIS-Developer] Can't import GeoPackage generated by QGIS into PostGIS

Anita Graser anitagraser at gmx.at
Sat Mar 30 13:55:03 PDT 2019


Hi,

I have a CSV with multiple columns including some WKT columns containing
polygon definitions. I've exported the layer as GeoPackage. Later, I wanted
to import the GeoPackage content to PostGIS but the import fails because
the WKT strings are longer than the fields DB Manager creates. The layer
properties state that the WKT columns are text(255) but the strings are
considerably longer.

(If I directly import the CSV to PostGIS, all is well.)

I'm not sure what kind of ticket I should open ...
- Option #1: DB Manager should be more fault tolerant and create less
restrictive columns
- Option #2: QGIS shouldn't create GeoPackages that store long strings in
field defined as text(255)

What do you recommend?

Regards,
Anita
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190330/7f187723/attachment.html>


More information about the QGIS-Developer mailing list