<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Michael -</p>
<p><br>
</p>
<p>All your questions are pertinent and needs to be redressed. <br>
</p>
<p><br>
</p>
<p>However one small personal nitpick: If I had a task involving
importing 200 or more layers into Postgres from some other
data-source I would never use DBManager import with it's manual
point-and-click. That's simply to risky<br>
</p>
<p><br>
</p>
<p> I would use a command-line tool OGR2OGR, which is included in
the QGIS installation: <a class="moz-txt-link-freetext" href="https://gdal.org/drivers/vector/pg.html">https://gdal.org/drivers/vector/pg.html</a>. It
can be started using the shortcut "OSGeo4W Shell" placed in the
same program group as QGIS.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Med venlig hilsen / Kind regards
Bo Victor Thomsen</pre>
<p> <br>
</p>
<div class="moz-cite-prefix">Den 19-04-2020 kl. 16:35 skrev Michael
Dufty:<br>
</div>
<blockquote type="cite"
cite="mid:MEAPR01MB453522586DAB028AE8ECA4769CD70@MEAPR01MB4535.ausprd01.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span>Thanks Jorge,</span></div>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span>The DB manager also 'just works' apparently regardless of
which boxed I tick. I'd just like to know what is going on or
if I'm setting myself up for a problem later on if I load up
200 layers with the wrong boxes ticked.</span></div>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span><br>
</span></div>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span>Looking more closely, it has got text greyed out if you
don't check a box, which may mean it is setting it to the
defaults shown, and you only check the box if you want to
change it.</span></div>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span><br>
</span></div>
<div style="color: rgb(0, 0, 0); font-family:
Calibri,Arial,Helvetica,sans-serif; font-size: 12pt;">
<span>It would be nice to know more rather than guessing.</span></div>
<div>
<div style="color:rgb(0,0,0);
font-family:Calibri,Arial,Helvetica,sans-serif;
font-size:12pt">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>From:</b>
Jorge Gustavo Rocha <a class="moz-txt-link-rfc2396E" href="mailto:jgr@geomaster.pt"><jgr@geomaster.pt></a><br>
<b>Sent:</b> Sunday, 19 April 2020 5:41 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:qgis-user@lists.osgeo.org"><qgis-user@lists.osgeo.org></a><br>
<b>Subject:</b> Re: [Qgis-user] Options when loading layers
into PostGIS with DBManager</font>
<div> </div>
</div>
<div>
<p>Hi Michael,</p>
<p>An alternative is to use the "Browser panel". I use it to
drag layers from the Layer panel into Postgresql. You don't
have to choose any parameters. It just works.</p>
<p>Regards,</p>
<p>Jorge Gustavo<br>
</p>
<div class="x_moz-cite-prefix">On 19/04/20 09:42, Michael
Dufty wrote:<br>
</div>
<blockquote type="cite">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Hi,</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
I am trying out saving data in PostGIS, and have got
stuck on the upload “import layer/file” dialog in DB
Manager.</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Can anyone recommend a good reference on what options
should be selected?</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
It seems to fall into a gap between PostGIS
documentation and QGIS documentation and I can’t find
any information on what should be selected in what
circumstances.</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
In particular</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Primary key – should this be ticked and the existing id
field selected? What happens if it is left unticked?</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Geometry column – is this needed? Objects still seem to
have geometry if it is left out.
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Create spatial index – this sounds like a good idea, but
the one youtube tutorial I found (Klas Karlson) he left
it unticked and said the layer already had everything.
Is it needed for some source formats and not others eg
shapefile vs geopackage?
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Convert field names to lower case doesn’t sound very
useful, but I presume it is there for a reason, does
anyone know the circumstances that would be needed?</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
Cheers,</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
<b><span style="color:#1F497D">Michael Dufty</span></b><span
style="color:#1F497D"></span></p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
<b><span style="font-size:10.0pt; color:#1F497D">Senior
Environmental Engineer</span></b><span
style="color:#1F497D"></span></p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
<span style="color:#1F497D"> </span></p>
<table class="x_MsoNormalTable"
style="border-collapse:collapse" cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:73.05pt; padding:0cm 5.4pt 0cm
5.4pt" width="97" valign="top">
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif;
font-size: 11pt;">
<span style="color:#1F497D"><img
id="x_Picture_x0020_1" style="width:.5729in;
height:.6354in" data-outlook-trace="F:1|T:1"
src="cid:part1.A42266DA.844BB8D9@gmail.com"
class="" width="55" height="61"></span><span
style="color:#993366"></span></p>
</td>
<td style="width:148.85pt; padding:0cm 5.4pt 0cm
5.4pt" width="198" valign="top">
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif;
font-size: 11pt;">
<b><span style="font-size:10.0pt; color:#1F497D;
text-transform:uppercase">MBS ENVIRONMENTAL</span></b><b><span
style="font-size:8.0pt; color:#3A5E9A;
text-transform:uppercase"><br>
</span></b><span style="font-size:7.5pt;
color:#1F497D">4 Cook Street, West
Perth WA 6005</span><span style=""
lang="ZH-TW">
</span><span
style="font-size:7.5pt; color:#1F497D"><br>
t: +61 8 9226-3166<br>
f: +61 8 9226-3177</span><span
style="font-size:7.5pt; color:#1F497D"></span></p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif;
font-size: 11pt;">
<span style="font-size:7.5pt; color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif;
font-size: 11pt;">
<span style="font-size:7.5pt; color:#1F497D">e:
<a
href="mailto:mdufty@mbsenvironmental.com.au"
moz-do-not-send="true">
<span style="color:blue">mdufty@mbsenvironmental.com.au</span></a>
<br>
w: </span><span
style="font-family:"Helvetica",sans-serif;
color:#1F497D"><a
title="blocked::http://www.mbsenvironmental.com.au/
http://www.mbsenvironmental.com.au/
blocked::http://www.mbsenvironmental.com.au/"
href="" moz-do-not-send="true"><span
style="font-size:7.5pt;
font-family:"Calibri",sans-serif;
color:#1F497D">www.mbsenvironmental.com.au</span></a></span><span
style="color:#993366"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;margin-bottom:12.0pt">
<span style="font-size:7.5pt; color:#999999">Disclaimer: <br>
The information contained in this message is intended
for those to whom it is addressed. It may contain
confidential or privileged information and if you are
not the intended recipient, you must not copy,
distribute or take any action in reliance on it. If
you received this message in error please destroy it
and reply to the sender immediately or contact
Martinick Bosch Sell Pty Ltd. on +61 8 9226 3166
immediately. All care has been taken to ensure that
this message and any attachments are virus free; we do
not accept responsibility for any virus infections
caused by receipt of this message</span><i><span
style="font-size:8.0pt; color:#999999"></span></i></p>
<p class="x_MsoNormal" style="margin: 0cm 0cm 0pt;
font-family: "Calibri",sans-serif; font-size:
11pt;">
</p>
</div>
<br>
<fieldset class="x_mimeAttachmentHeader"></fieldset>
<pre class="x_moz-quote-pre">_______________________________________________
Qgis-user mailing list
<a class="x_moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a>
List info: <a class="x_moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="x_moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<div class="x_moz-signature">-- <br>
<table style="width:525px; font-size:11pt;
font-family:Arial,sans-serif" cellspacing="0"
cellpadding="0">
<tbody>
<tr>
<td style="text-align:center; font-size:10pt;
font-family:Arial,sans-serif; border-right:1px
solid; border-right-color:#fb6303; width:125px;
padding-right:10px; vertical-align:top" rowspan="6"
width="125" valign="top">
<a href="https://www.geomaster.pt" target="_blank"
moz-do-not-send="true"><img style="width:105px;
height:auto; border:0" alt="Logo"
src="https://geomaster.pt/wp-content/uploads/2017/02/cropped-geomaster300x300-1.png"
moz-do-not-send="true" width="85" border="0"></a>
</td>
<td style="padding-left:10px">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="font-size:10pt; color:#0079ac;
font-family:Arial,sans-serif; width:400px;
padding-bottom:5px; padding-left:10px;
vertical-align:top" valign="top">
<strong><span style="font-size:14pt;
font-family:Arial,sans-serif;
color:#fb6303">Geomaster</span></strong><br>
<strong><span style="font-size:11pt;
font-family:Arial,sans-serif;
color:black">Jorge Gustavo Rocha</span></strong>
<span style="font-family:Arial,sans-serif;
font-size:11pt; color:#000000"><span
style="padding-right:5px;
padding-left:5px">|
</span>Software Engineer</span> </td>
</tr>
<tr>
<td style="font-size:10pt; color:#444444;
font-family:Arial,sans-serif;
padding-bottom:5px; padding-top:5px;
padding-left:10px; vertical-align:top;
line-height:17px" valign="top">
<span><span style="color:#fb6303"><strong>e:</strong></span><span
style="font-size:10pt;
font-family:Arial,sans-serif;
color:#000000">
<a class="x_moz-txt-link-abbreviated"
href="mailto:jgr@geomaster.pt"
moz-do-not-send="true">jgr@geomaster.pt</a></span></span>
<span><span style="padding-left:5px;
padding-right:5px">| </span><span
style="color:#fb6303"><strong>m:</strong></span><span
style="font-size:10pt;
font-family:Arial,sans-serif;
color:#000000"> +351 910 333 888<br>
</span></span><span><span
style="color:#fb6303"><strong>g:</strong></span><span
style="font-size:10pt;
font-family:Arial,sans-serif;
color:#000000"> 41.54094,-8.40490</span></span>
<span><span style="padding-left:7px;
padding-right:5px">| </span><span
style="color:#fb6303"><strong>v:
</strong></span><span
style="font-size:10pt;
font-family:Arial,sans-serif;
color:#000000; padding-left:7px">510 906
109<br>
</span></span><span><span
style="color:#fb6303"><strong>a: </strong></span></span><span><span
style="font-size:10pt;
font-family:Arial,sans-serif;
color:#000000"><span></span>Rua António
Cândido Pinto, 67, 4715-400 Braga<br>
</span></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>