Hey List!*
**
*I'm having trouble tracking down an answer to a question, from either the archived mailing list or google, I have about ogr2ogr and loading data to PostGIS.
*
*Basically, what's the difference between the -overwrite flag and the layer creation option OVERWRITE for the PostgreSQL/PostGIS driver?*
**
*The descriptions are a little similar and I can't think of how they should be used differently.*
**
*For example, they say*:**
**


*
-overwrite:
   Delete the output layer and recreate it empty
*
*
OVERWRITE*: This may be "YES" to force an existing layer of the desired name to be destroyed before creating the requested layer.*
*


*They either say they "delete" or "destroy" (is there a difference?) the layer prior to insert/copy but then one says "recreate it empty" which I can't see it producing an empty layer, and the other one says "creating the requested layer".

On another issue, I used to just use options like "-update -progress -unsetFid --config OGR_TRUNCATE YES -gt 65536" so that en existing table in the database could be updated without deleting VIEWS and user permissions. But unfortunately, one of the datasets I got recently has all the fields renamed so I have to get creative with the -fieldmap option or the new -addfields (but that means I have to delete the old redundant fields afterwards).





--
Kind regards,

Donovan

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to