<div dir="ltr">That's cool.<div>Had not yet run into this, but was probably going to pretty soon.</div><div>Thanks!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 29, 2020 at 6:28 PM jratike80 <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
I would have a try with open option LIST_ALL_TABLES=YES<br>
<a href="https://gdal.org/drivers/vector/pg.html" rel="noreferrer" target="_blank">https://gdal.org/drivers/vector/pg.html</a>.<br>
"LIST_ALL_TABLES=YES/NO: This may be “YES” to force all tables, including<br>
non-spatial ones, to be listed." It is probably worth reading<br>
<a href="https://gdal.org/drivers/vector/gpkg.html" rel="noreferrer" target="_blank">https://gdal.org/drivers/vector/gpkg.html</a> as well, about the layer creation<br>
options and aspatial tables.<br>
<br>
<br>
-Jukka Rahkonen-<br>
<br>
<br>
<br>
<br>
ghtmtt wrote<br>
> Hi all,<br>
> <br>
> I'd like to export all the table of a PG schema to either GPKG or a <br>
> shapefiles.<br>
> <br>
> In the schema I've a lot of non-spatial tables and with something like:<br>
> <br>
> ogr2ogr -f GPKG output.gpkg "PG:dbname=mydb schemas=myschema user=myuser <br>
> password=mypws host=myhost" -progress<br>
> <br>
> the output is generated but it only contains geometric tables. I <br>
> couldn't find a parameter to force the export of also non-spatial tables.<br>
> <br>
> What I'd like to avoid is to loop on every single layer<br>
> <br>
> Cheers and thanks<br>
> <br>
> Matteo<br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
<br>
> gdal-dev@.osgeo<br>
<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html</a><br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div>