[gdal-dev] ogr2ogr postgis to sqlite composite primary key issueissue

Brent Wood pcreso at yahoo.com
Tue Aug 15 17:12:29 PDT 2023


Hi,
I'm looking to use ogr2ogr to replicate a Postgis schema into a Spatialite database. (Make a snapshot copy of institutional tables on a field laptop with possible no internet access)

I have a script to identify the relevant tables and invoke ogr2ogr to copy each table.
Some of the source (Postgis) tables have a composite primary key. ogr2ogr flags these and says such keys are unsupported. It fails to copy these tables.
What I'd like it to do is copy the data in such cases but ignore the primary key. 

Is this possible?

Thanks,
Brent Wood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230816/13a6477c/attachment.htm>


More information about the gdal-dev mailing list