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

[Jorge Gustavo Rocha]

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
> <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
> 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
-- 
Email Signature
Logo <https://www.geomaster.pt> 	
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200419/510e3905/attachment-0001.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/510e3905/attachment-0001.jpg>