[Qgis-user] Insert Selected Fields From ESRI Shape-File To PostGIS Geometry Table

[Richard McDonnell]

Hi,
I haven't tried this, but......You could try inserting the PostGIS Table 
you wish to add the data too, then make it editable by toggling editing.
Copy the data selected in the Shapefile and then paste it into the 
editable Database Table. You can then make the DB Table toggle editing 
again, saving the edits.
At this point I would save a copy of the updated DB Table locally (Just 
to be sure/Just in case).
Remove the inserted DB table and then re-insert it, to check the changes 
(additional data and attribution) have been updated on the Database side.
If not, use the Edited version you saved locally to overwrite the whole 
table on the Database, using the DB Manager

I hope this helps in some way.



Regards,

Richard*
*
On 06/06/2017 15:53, Osahon Oduware wrote:
> Hi,
>
> I added an ESRI Shape file as a layer in QGIS (version 2.14) using the 
> "Add vector layer" tool. Now, I want to import selected fields 
> (including the geometry) from this shape-file layer into an existing 
> PostGIS Geometry table.
>
> I have tried using the import layer/file tool in the Database Manager 
> menu, but this seems to be only able to create an existing table which 
> doesn't suit my need as described above.
>
> I learnt GeoMedia does something similar to what I am trying to 
> accomplish i.e. it automatically loads the matching fields in the 
> shape file layer into the corresponding fields in the database table.
>
> Please, I need someone to direct me on how to accomplish this.
>
>
> _______________________________________________
> 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

-- 
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170606/d104f4cf/attachment.html>