[Qgis-user] Insert Selected Fields From ESRI Shape-File To PostGIS Geometry Table
Richard McDonnell
richard.mcdonnell at opw.ie
Tue Jun 6 08:46:15 PDT 2017
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>
More information about the Qgis-user
mailing list