Hi, No, -overwrite does not truncate but it drops the table. However, with the PostgreSQL driver it is also possible to truncate the table by using this documented method https://gdal.org/drivers/vector/pg.html#vector-pg. Check the configuration options
"OGR_TRUNCATE: If set to “YES”, the content of the table will be first erased with the SQL TRUNCATE command before inserting the first feature. This is an alternative to using the -overwrite flag of ogr2ogr, that avoids views based on the table to be destroyed. Typical use case: “ogr2ogr -append PG:dbname=foo abc.shp –config OGR_TRUNCATE YES”." -Jukka Rahkonen- ghtmtt wrote > > Just for information: -overwrite is doing a "truncate table" before > adding the new features? Is this the reason that FK, CHECKS and other > customization will be lost? > > Cheers and thanks > > Matteo -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev