Re: [gdal-dev] exporting all tables from PG schema

Got it! --config PG_LIST_ALL_TABLES YES :) Thanks Matteo ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] exporting all tables from PG schema

That's cool. Had not yet run into this, but was probably going to pretty soon. Thanks! On Tue, Dec 29, 2020 at 6:28 PM jratike80 < jukka.rahko...@maanmittauslaitos.fi> wrote: > Hi, > > I would have a try with open option LIST_ALL_TABLES=YES > https://gdal.org/drivers/vector/pg.html. > "LIST_ALL_T

Re: [gdal-dev] exporting all tables from PG schema

Hi, I would have a try with open option LIST_ALL_TABLES=YES https://gdal.org/drivers/vector/pg.html. "LIST_ALL_TABLES=YES/NO: This may be “YES” to force all tables, including non-spatial ones, to be listed." It is probably worth reading https://gdal.org/drivers/vector/gpkg.html as well, about the

[gdal-dev] exporting all tables from PG schema

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 gener