<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Answering my own question again.<o:p></o:p></p>
<p class="MsoNormal">It does look like leaving everything alone works pretty well.<o:p></o:p></p>
<p class="MsoNormal">Primary key unchecked results in a primary key being set up with the id column as shown in grey. This caused a problem when the layer had a pre-existing non-unique id column. Works fine if the existing id column has unique values, or
does not exist.<o:p></o:p></p>
<p class="MsoNormal">Leaving the geometry column unticked seems to create a geom column (as shown in grey).<o:p></o:p></p>
<p class="MsoNormal">If a spatial index is needed and wasn’t ticked, a warning will show in db manager afterwards and it is easy to create one from there.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Just needs the documentation update to say not to worry about it. A bit like the lack of documentation on how to upgrade an existing install. It doesn’t seem to matter what you do, but you can waste a lot of time trying to look it up
if too cautious.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><b><span style="color:#1F497D;mso-fareast-language:EN-GB">Michael Dufty</span></b><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D;mso-fareast-language:EN-GB">Senior Environmental Engineer</span></b><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="97" valign="top" style="width:73.05pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-AU"><img width="55" height="61" style="width:.5729in;height:.6354in" id="Picture_x0020_2" src="cid:image001.jpg@01D6169E.C91D6900"></span><span style="color:#993366"><o:p></o:p></span></p>
</td>
<td width="198" valign="top" style="width:148.85pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D;text-transform:uppercase;mso-fareast-language:EN-GB">MBS ENVIRONMENTAL</span></b><b><span style="font-size:8.0pt;color:#3A5E9A;text-transform:uppercase;mso-fareast-language:EN-GB"><br>
</span></b><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB">4 Cook Street, West Perth WA 6005</span><span lang="ZH-TW" style="font-size:7.5pt;font-family:"MS Gothic";color:#1F497D;mso-fareast-language:ZH-TW">
</span><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB"><br>
t: +61 8 9226-3166<br>
f: +61 8 9226-3177</span><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB">e:
<a href="mailto:mdufty@mbsenvironmental.com.au">mdufty@mbsenvironmental.com.au</a>
<br>
w: </span><span style="font-family:"Helvetica",sans-serif;color:#1F497D;mso-fareast-language:EN-GB"><a href="blocked::http://www.mbsenvironmental.com.au/" title="blocked::http://www.mbsenvironmental.com.au/
http://www.mbsenvironmental.com.au/ blocked::http://www.mbsenvironmental.com.au/"><span style="font-size:7.5pt;font-family:"Calibri",sans-serif;color:#1F497D">www.mbsenvironmental.com.au</span></a></span><span style="color:#993366"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:7.5pt;color:#999999;mso-fareast-language:EN-AU">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;mso-fareast-language:EN-AU"><o:p></o:p></span></i></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-AU"> Michael Dufty <MDufty@mbsenvironmental.com.au>
<br>
<b>Sent:</b> Sunday, 19 April 2020 4:43 PM<br>
<b>To:</b> qgis-user@lists.osgeo.org<br>
<b>Subject:</b> [Qgis-user] Options when loading layers into PostGIS with DBManager<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal">I am trying out saving data in PostGIS, and have got stuck on the upload “import layer/file” dialog in DB Manager.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can anyone recommend a good reference on what options should be selected?<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In particular<o:p></o:p></p>
<p class="MsoNormal">Primary key – should this be ticked and the existing id field selected? What happens if it is left unticked?<o:p></o:p></p>
<p class="MsoNormal">Geometry column – is this needed? Objects still seem to have geometry if it is left out.
<o:p></o:p></p>
<p class="MsoNormal">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? <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="color:#1F497D;mso-fareast-language:EN-GB">Michael Dufty</span></b><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D;mso-fareast-language:EN-GB">Senior Environmental Engineer</span></b><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="97" valign="top" style="width:73.05pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-AU"><img border="0" width="55" height="61" style="width:.5729in;height:.6354in" id="Picture_x0020_1" src="cid:image001.jpg@01D6169E.C91D6900"></span><span style="color:#993366"><o:p></o:p></span></p>
</td>
<td width="198" valign="top" style="width:148.85pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#1F497D;text-transform:uppercase;mso-fareast-language:EN-GB">MBS ENVIRONMENTAL</span></b><b><span style="font-size:8.0pt;color:#3A5E9A;text-transform:uppercase;mso-fareast-language:EN-GB"><br>
</span></b><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB">4 Cook Street, West Perth WA 6005</span><span lang="ZH-TW" style="font-size:7.5pt;font-family:"MS Gothic";color:#1F497D;mso-fareast-language:ZH-TW">
</span><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB"><br>
t: +61 8 9226-3166<br>
f: +61 8 9226-3177<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:#1F497D;mso-fareast-language:EN-GB">e:
<a href="mailto:mdufty@mbsenvironmental.com.au">mdufty@mbsenvironmental.com.au</a>
<br>
w: </span><span style="font-family:"Helvetica",sans-serif;color:#1F497D;mso-fareast-language:EN-GB"><a href="blocked::http://www.mbsenvironmental.com.au/" title="blocked::http://www.mbsenvironmental.com.au/
http://www.mbsenvironmental.com.au/ blocked::http://www.mbsenvironmental.com.au/"><span style="font-size:7.5pt;font-family:"Calibri",sans-serif;color:#1F497D">www.mbsenvironmental.com.au</span></a></span><span style="color:#993366"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:7.5pt;color:#999999;mso-fareast-language:EN-AU">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;mso-fareast-language:EN-AU"><o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>