[gdal-dev] exporting all tables from PG schema

matteo matteo.ghetta at gmail.com
Tue Dec 29 07:25:57 PST 2020


Hi all,

I'd like to export all the table of a PG schema to either GPKG or a 
shapefiles.

In the schema I've a lot of non-spatial tables and with something like:

ogr2ogr -f GPKG output.gpkg "PG:dbname=mydb schemas=myschema user=myuser 
password=mypws host=myhost" -progress

the output is generated but it only contains geometric tables. I 
couldn't find a parameter to force the export of also non-spatial tables.

What I'd like to avoid is to loop on every single layer

Cheers and thanks

Matteo


More information about the gdal-dev mailing list