[gdal-dev] exporting all tables from PG schema

[Jan Heckman]

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.rahkonen at 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_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 layer
> creation
> options and aspatial tables.
>
>
> -Jukka Rahkonen-
>
>
>
>
> ghtmtt wrote
> > 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
> > _______________________________________________
> > gdal-dev mailing list
>
> > gdal-dev at .osgeo
>
> > https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20201229/f0d991e3/attachment.html>