I would like to upload a specific table (i.e. U2018_CLC2012_V2020_20u1 (Multi Polygon)
) from a Geopackage file to a PostGIS database from the command line. I tried:
ogr2ogr -f "PostgreSQL" "PG:database" \
-t_srs EPSG:3035 -overwrite -lco GEOMETRY_NAME=geom -nln "corine.corine12_vec" \
U2018_CLC2012_V2020_20u1.gpkg
However, I just realized, the Geopackage contains multiple tables and only (the wrong) one (i.e. U2018_CLC2012_V2020_20u1_FR_MYT (Multi Polygon)
) is uploaded.
Q: How can I upload a specific table or all tables?
Output of ogrinfo U2018_CLC2012_V2020_20u1.gpkg
:
INFO: Open of `U2018_CLC2012_V2020_20u1.gpkg'
using driver `GPKG' successful.
1: U2018_CLC2012_V2020_20u1 (Multi Polygon)
2: U2018_CLC2012_V2020_20u1_FR_REU (Multi Polygon)
3: U2018_CLC2012_V2020_20u1_FR_GLP (Multi Polygon)
4: U2018_CLC2012_V2020_20u1_FR_GUF (Multi Polygon)
5: U2018_CLC2012_V2020_20u1_FR_MTQ (Multi Polygon)
6: U2018_CLC2012_V2020_20u1_FR_MYT (Multi Polygon)