ogr2ogr
Verified for current stable LTS
Ogr2ogr Command: Load Geopackage Into Postgis Database
Use for load geopackage into postgis database with Ogr2ogr. Exact CLI syntax to load geopackage into postgis database using Ogr2ogr.
When to use this: Use for load geopackage into postgis database with Ogr2ogr.
Destructive Command Warning
Destructive operation. Confirm the target path and keep a backup before executing.
Command Syntax
ogr2ogr -f PostgreSQL PG:dbname="<database_name>" <path/to/input.gpkg>ogr2ogr -f PostgreSQL PG:dbname="<database_name>" <path/to/input.gpkg>Command Breakdown
-f- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to load geopackage into postgis database using Ogr2ogr.
Test path: Replace placeholders and run destructive commands in a disposable workspace first.
Flag behavior: Tool version, platform, and shell can change behavior.
Improve This Command
Suggest a correction, safer default, or version-specific note for this entry.
Related Operations
Ogr2ogr Command: Change Coordinate Reference System Geopackage
ogr2ogr -s_srs {EPSG:4326} -t_srs {EPSG:3857} -f GPKG <path/to/output.gpkg> <path/to/input.gpkg> Ogr2ogr Command: Clip Geopackage Layers To Bounding Box ogr2ogr -spat <min_x> <min_y> <max_x> <max_y> -f GPKG <path/to/output.gpkg> <path/to/input.gpkg> Ogr2ogr Command: Convert Csv To Geopackage With Coordinates ogr2ogr -f GPKG <path/to/output.gpkg> <path/to/input.csv> -oo X_POSSIBLE_NAMES=<longitude> -oo Y_POSSIBLE_NAMES=<latitude> -a_srs {EPSG:4326} Ogr2ogr Command: Convert Shapefile To Geopackage ogr2ogr -f GPKG <path/to/output.gpkg> <path/to/input.shp> Ogr2ogr Command: Reduce Geojson Features By Condition ogr2ogr -where '<myProperty > 42>' -f <GeoJSON> <path/to/output.geojson> <path/to/input.geojson>