[Qgis-user] Options when loading layers into PostGIS with DBManager

[Michael Dufty]

Thanks Jorge,
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.

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.

It would be nice to know more rather than guessing.

________________________________
From: Jorge Gustavo Rocha <jgr at geomaster.pt>
Sent: Sunday, 19 April 2020 5:41 PM
To: qgis-user at lists.osgeo.org <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] Options when loading layers into PostGIS with DBManager


Hi Michael,

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.

Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:

Hi,

I am trying out saving data in PostGIS, and have got stuck on the upload “import layer/file” dialog in DB Manager.



Can anyone recommend a good reference on what options should be selected?

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.



In particular

Primary key – should this be ticked and the existing id field selected? What happens if it is left unticked?

Geometry column – is this needed? Objects still seem to have geometry if it is left out.

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?



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?



Cheers,





Michael Dufty

Senior Environmental Engineer



[cid:part1.109C90E4.CCE4590B at geomaster.pt]

MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:    +61 8 9226-3166
f:    +61 8 9226-3177



e:   mdufty at mbsenvironmental.com.au<mailto:mdufty at mbsenvironmental.com.au>
w:   www.mbsenvironmental.com.au

Disclaimer:
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





_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

--
[Logo]<https://www.geomaster.pt>
Geomaster
Jorge Gustavo Rocha | Software Engineer
e: jgr at geomaster.pt<mailto:jgr at geomaster.pt> | m: +351 910 333 888
g: 41.54094,-8.40490 | v: 510 906 109
a: Rua António Cândido Pinto, 67, 4715-400 Braga
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200419/fa099240/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1513 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200419/fa099240/attachment.jpg>