Hi, I think that shapefile does not have a proper fid to preserve. I am remembering that I have used the -sql option sometimes for controlling the FID, something like -sql “SELECT geometry, id AS FID, attribute_1, attribute_2 … FROM …”
-Jukka Rahkonen- Lähettäjä: gdal-dev <gdal-dev-boun...@lists.osgeo.org> Puolesta Alexandre Gacon Lähetetty: torstai 13. lokakuuta 2022 11.13 Vastaanottaja: gdal-dev <gdal-dev@lists.osgeo.org> Aihe: [gdal-dev] ogr2ogr preserve fid behavior 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
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev