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
