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

[Paolo Cavallini]

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 <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
> 
> 
> _______________________________________________
> 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
> 

-- 
Paolo Cavallini - QGIS.ORG Chair
www.faunalia.eu:
training, support, development on QGIS, PostGIS and more