Another easy option is to use Processing, with its batch capabilities. Cheers.
Il 19/04/20 18:08, Bo Victor Thomsen ha scritto: > Hi Michael - > > > All your questions are pertinent and needs to be redressed. > > > However one small personal nitpick: If I had a task involving importing > 200 or more layers into Postgres from some other data-source I would > never use DBManager import with it's manual point-and-click. That's > simply to risky > > > I would use a command-line tool OGR2OGR, which is included in the QGIS > installation: https://gdal.org/drivers/vector/pg.html. It can be started > using the shortcut "OSGeo4W Shell" placed in the same program group as QGIS. > > > > -- > Med venlig hilsen / Kind regards > > Bo Victor Thomsen > > > Den 19-04-2020 kl. 16:35 skrev 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 <[email protected]> >> *Sent:* Sunday, 19 April 2020 5:41 PM >> *To:* [email protected] <[email protected]> >> *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* >>> >>> >>> >>> >>> >>> *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 >>> >>> 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] <mailto:[email protected]> >>> 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:*[email protected] <mailto:[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 > > > _______________________________________________ > 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 > -- Paolo Cavallini - QGIS.ORG Chair www.faunalia.eu: training, support, development on QGIS, PostGIS and more _______________________________________________ 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
