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@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/
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
