Hi Michael, it should "just work" with all the defaults, as you mention. Exceptions are the id issue you noticed and the SINGLE/MULTI option: usually you want SINGLE for points. Cheers.
Il 19/04/20 17:05, Michael Dufty ha scritto: > Answering my own question again. > > It does look like leaving everything alone works pretty well. > > 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. > > Leaving the geometry column unticked seems to create a geom column (as > shown in grey). > > 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. > > > > 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. > > > > *Michael Dufty* > > *Senior Environmental Engineer* > > > > > > *MBS ENVIRONMENTAL** > *4 Cook Street, West Perth WA 6005 > t: +61 8 9226-3166 > f: +61 8 9226-3177 > > > > e: mdu...@mbsenvironmental.com.au <mailto:mdu...@mbsenvironmental.com.au> > w: www.mbsenvironmental.com.au > <blocked::http://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// > > > > *From:*Michael Dufty <mdu...@mbsenvironmental.com.au> > *Sent:* Sunday, 19 April 2020 4:43 PM > *To:* qgis-user@lists.osgeo.org > *Subject:* [Qgis-user] Options when loading layers into PostGIS with > DBManager > > > > 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* > > > > > > *MBS ENVIRONMENTAL** > *4 Cook Street, West Perth WA 6005 > t: +61 8 9226-3166 > f: +61 8 9226-3177 > > > > e: mdu...@mbsenvironmental.com.au <mailto:mdu...@mbsenvironmental.com.au> > w: www.mbsenvironmental.com.au > <blocked::http://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@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > -- Paolo Cavallini - QGIS.ORG Chair www.faunalia.eu: training, support, development on QGIS, PostGIS and more _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
