<html><head></head><body><div class="ydp76f4b176yahoo-style-wrap" style="font-family:verdana, helvetica, sans-serif;font-size:16px;"><div></div>
<div dir="ltr" data-setdir="false">Thanks, <br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">The primary key on the source tables is on required columns - it is a natural key based on core data so cannot be excluded to have a meaningful dataset exported.<br></div><div><br></div><div dir="ltr" data-setdir="false">Also, invoking it your way provides a data only export - just the output of a select statement. I'm trying to create replicate data structures populated with the data in the Spatialite database.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">It seems that using an intermediate format such as shapefile should work, as this will essentially drop any primasry key anyway, but I'm trying the direct approach first.<br></div><div><br></div><div dir="ltr" data-setdir="false">Also, your example exports to geopackage, that is not what I'm after, Spatialite is much more than geopackage.<br></div><div><br></div><div dir="ltr" data-setdir="false">Cheers<br></div><div><br></div><div dir="ltr" data-setdir="false">Brent</div><div dir="ltr" data-setdir="false"><br></div>
</div><div id="ydpfd950e6byahoo_quoted_2899629105" class="ydpfd950e6byahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, August 16, 2023 at 12:57:14 PM GMT+12, Scott <public@postholer.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">You could build your column list without that specific column and pass <br clear="none">it to ogr2ogr (bash):<br clear="none"><br clear="none">ogr2ogr -sql "select $(psql -d mydb --pset='footer=off' -F',' -qAc <br clear="none">"select * from table where false" |sed 's/columnToOmit,//g') from table" <br clear="none">target.gpkg PG:dbname=mydb<br clear="none"><br clear="none"><br clear="none">On 8/15/23 17:12, Brent Wood via gdal-dev wrote:<br clear="none">> Hi,<br clear="none">> <br clear="none">> I'm looking to use ogr2ogr to replicate a Postgis schema into a <br clear="none">> Spatialite database. (Make a snapshot copy of institutional tables on a <br clear="none">> field laptop with possible no internet access)<br clear="none">> <br clear="none">> I have a script to identify the relevant tables and invoke ogr2ogr to <br clear="none">> copy each table.<br clear="none">> <br clear="none">> Some of the source (Postgis) tables have a composite primary key. <br clear="none">> ogr2ogr flags these and says such keys are unsupported. It fails to copy <br clear="none">> these tables.<br clear="none">> <br clear="none">> What I'd like it to do is copy the data in such cases but ignore the <br clear="none">> primary key.<br clear="none">> <br clear="none">> Is this possible?<br clear="none">> <br clear="none">> <br clear="none">> Thanks,<br clear="none">> <br clear="none">> Brent Wood<br clear="none">> <br clear="none">> _______________________________________________<br clear="none">> gdal-dev mailing list<br clear="none">> <a shape="rect" href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a><br clear="none">> <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><div class="ydpfd950e6byqt2937531691" id="ydpfd950e6byqtfd01846"><br clear="none">_______________________________________________<br clear="none">gdal-dev mailing list<br clear="none"><a shape="rect" href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a><br clear="none"><a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br clear="none"></div></div></div>
</div>
</div></body></html>