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?
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)