PG2GPKG
Plugin ID: 4745
Bidirectional bridge between PostgreSQL/PostGIS and GeoPackage: export databases to GPKG and import GPKG into PostGIS.
(5) votes
PG2GPKG moves data both ways between PostgreSQL/PostGIS and GeoPackage.
EXPORT (PostgreSQL → GeoPackage):
• One GeoPackage per schema
• Everything in a single GeoPackage
• One GeoPackage per table
• Automatic QGIS project export with datasource path rewriting
IMPORT (GeoPackage → PostgreSQL):
• Multi-layer batch import with per-layer destination schema/table
• Append, replace or create modes
• Interactive field mapping (rename / exclude columns)
• Optional reprojection to a target SRID
• Fast COPY-based loading via GDAL (PG_USE_COPY)
General:
• Tree/table-based layer selection with geometry info
• Handles fid type conflicts, compressed project formats, and SSL mode normalization
• Filters system tables automatically
• Full Italian and English interface
