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

Sun Apr 19 09:08:13 PDT 2020

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 <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*
>>
>> 	
>>
>> *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
>
>
> _______________________________________________
> Qgis-user mailing list
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200419/cb3bcf6b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1513 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200419/cb3bcf6b/attachment.jpg>