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

[Anita Graser]

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>