[gdal-dev] ogr2ogr preserve fid behavior

Alexandre Gacon alexandre.gacon at gmail.com
Thu Oct 13 01:13:29 PDT 2022


Hello,

I am trying to upload some data from SHP to Postgres. I would like to use a
given column of my SHP as primary key in replacement of the id generated by
ogr2ogr but I don't manage to have the result I want.

I used the options -preserve_fid and --config PGSQL_OGR_FID id which gave
the following output: I have a column "id" as primary key but it does not
contain the value of my SHP but an auto increment value.

The SHP is not used directly but I do some computations and name changes
using a sql statement with the sqlite dialect.

Any idea on how I could have directly my "id" column as primary key with
the values of my input ?

-- 
Alexandre Gacon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20221013/ea9a0eee/attachment.htm>


More information about the gdal-dev mailing list