Conversion between a String attribute of a Geopackage and a JSON field of PostgreSQL

[NicolaPx]

I tried to add some features from a geopackage into a PostGIS layer. A txt field formatted as a json field is not imported in the PostGIS json field. If we tried to import using the copy and past function in Qgis, the import correctly works.

[gacarrillor]

Thanks for the report, we'll have a look at it.

[gacarrillor]

I gave this a try. It's true that the plugin does not transfer a String field value into a JSON field.
However, that's also the case with the QGIS Copy&Paste functionality (at least from GPKG to GPKG layers).

Screen-cast on QGIS master (v.3.35):

Please let me know which QGIS version are you using and upload a screen-cast/screenshot or some sample data.

[gacarrillor]

I've added some tests for both QGIS 3.28.x and 3.34.x, which are current and next LTRs. (See #25 and #27)

Summary:

• GPKG to GPKG
  • String to JSON
  • JSON to JSON
    • Copy&paste single feature
    • Copy&paste multiple features
• GPKG to PG
  • String to JSON
  • JSON to JSON
    • Copy&paste single feature
    • Copy&paste multiple features (there is a QGIS bug here, still pending to investigate more)