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* > > > > > > *MBS ENVIRONMENTAL** > *4 Cook Street, West Perth WA 6005 > t: +61 8 9226-3166 > f: +61 8 9226-3177 > > > > e: [email protected] > <mailto:[email protected]> > 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- Email Signature Logo <https://www.geomaster.pt> *Geomaster* *Jorge Gustavo Rocha* | Software Engineer *e:*[email protected] | *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
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
