<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
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. <br>
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.<br>
At this point I would save a copy of the updated DB Table locally
(Just to be sure/Just in case).<br>
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.<br>
If not, use the Edited version you saved locally to overwrite the
whole table on the Database, using the DB Manager<br>
<br>
I hope this helps in some way.<br>
<br>
<br>
<br>
Regards,<br>
<br>
Richard<b><br>
</b><br>
<div class="moz-cite-prefix">On 06/06/2017 15:53, Osahon Oduware
wrote:<br>
</div>
<blockquote
cite="mid:CAGpiUSjEkDBjOA_UM11TRN3g65tz19AsEGW5=PuJt8ovG-j4hw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi,<br>
<br>
</div>
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.<br>
<br>
</div>
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.<br>
<br>
</div>
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.<br>
<br>
</div>
Please, I need someone to direct me on how to accomplish this.<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<p></p>
<a href="http://www.opw.ie/"><img src="http://www.opw.ie/en/media/opw-logo-december-2016.gif" width="405" height="225" /></a>
</body>
</html>