Hi I managed to get the expected result by removing the options -preserve_fid and --config PGSQL_OGR_FID id and by using an existing table set correctly with the right column as primary key.
Alexandre Le jeu. 13 oct. 2022 à 10:28, Rahkonen Jukka < jukka.rahko...@maanmittauslaitos.fi> a écrit : > 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 > -- Alexandre Gacon
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
