<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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="moz-cite-prefix">On 19/04/20 09:42, Michael Dufty wrote:<br>
</div>
<blockquote type="cite"
cite="mid:MEAPR01MB4535F9C2EBCBF6E2D402ED179CD70@MEAPR01MB4535.ausprd01.prod.outlook.com">
<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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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]-->
<div class="WordSection1">
<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" 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="MsoNormal"><span
style="color:#1F497D;mso-fareast-language:EN-AU"><img
style="width:.5729in;height:.6354in"
id="Picture_x0020_1"
src="cid:part1.109C90E4.CCE4590B@geomaster.pt"
class="" width="55" height="61"></span><span
style="color:#993366"><o:p></o:p></span></p>
</td>
<td style="width:148.85pt;padding:0cm 5.4pt 0cm 5.4pt"
width="198" valign="top">
<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
style="font-size:7.5pt;font-family:"MS
Gothic";color:#1F497D;mso-fareast-language:ZH-TW"
lang="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"
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;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/"
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"><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>
<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>
<div class="moz-signature">-- <br>
<title>Email Signature</title>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<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"><img alt="Logo" style="width:105px;
height:auto; border:0;"
src="https://geomaster.pt/wp-content/uploads/2017/02/cropped-geomaster300x300-1.png"
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="moz-txt-link-abbreviated" href="mailto:jgr@geomaster.pt">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>
</body>
</html>