<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hey List!<b><br>
</b><b><br>
</b>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.<br>
<b><br>
</b>Basically, what's the difference between the -overwrite flag and
the layer creation option OVERWRITE for the PostgreSQL/PostGIS
driver?<b><br>
</b><b><br>
</b>The descriptions are a little similar and I can't think of how
they should be used differently.<b><br>
</b><b><br>
</b>For example, they say<b>:</b><b><br>
</b><b><br>
<br>
<br>
</b>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<dt style="color: rgb(0, 0, 0); font-size: 14px; font-style: normal;
font-variant: normal; letter-spacing: normal; line-height: 22px;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 1; word-spacing: 0px;
background-color: rgb(255, 255, 255);"><big>-overwrite:</big></dt>
<dd style="color: rgb(0, 0, 0); font-size: 14px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: 22px; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: 1;
word-spacing: 0px; background-color: rgb(255, 255, 255);"><big>Delete
the output layer and recreate it empty</big></dd>
<dt><b><br>
</b></dt>
<dt>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<span style="color: rgb(0, 0, 0); font-size: medium; font-style:
normal; font-variant: normal; letter-spacing: normal;
line-height: normal; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: 1;
word-spacing: 0px; background-color: rgb(255, 255, 255);">OVERWRITE</span><span
style="color: rgb(0, 0, 0); font-size: medium; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; display: inline ! important;
float: none; background-color: rgb(255, 255, 255);"></span><b><span
style="color: rgb(0, 0, 0); font-size: medium; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; display: inline ! important;
float: none; background-color: rgb(255, 255, 255);">: This may
be "YES" to force an existing layer of the desired name to be
destroyed before creating the requested layer.</span></b></dt>
<b><br>
<br>
<br>
</b>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".<br>
<br>
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).<br>
<br>
<br>
<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
Kind regards,
Donovan</pre>
</body>
</html>