postgisqgis
I 'm running postgis with qgis 2.6. I created a database and tables that i need to update with new datas provided with shapes. I cannot find how to insert them in table. All attributes both shapes and table are same. I don't despair to have an "easy" way instead of using an insert to command that i'm not sure to use correctly in postgis command.
I've tried the database manager but i only succeed in erasing all previous data in the table >_<
Window 7 64 bits
Qgis2.6
Postgis1.5
Postgrsql 9.4
Do not use the regular "Add PostGIS Layers", it will not show your raster table. The plugin "Load Postgis Raster to QGIS" was not updated to QGIS v.2.0, so it won't work either.
In QGIS v.2.6 go to menu Database->DB Manager->DB Manager, set the database connection and you will see the raster table. You can drag and drop it or right click and select Add to canvas.
Note: There was a bug on loading PostGIS raster layers to QGIS, which was solved in v.2.6: http://hub.qgis.org/issues/8628 So, update your QGIS to v. >= 2.6
From QGIS >> DB Manager >> DB Manager
And you will have most of the option you need for your vector data to import into your database.
Best Answer
I's quite easy to copy-paste features from one layer to another. You start editing the PostGIS layer, then choose the new shape layer in the layer table of contents, os it's "active". Now use the select tool to select the features from the shape layer. And click the "Copy" button on the editing toolbar.
Now re-select the PostGIS layer in the table of contents, and click the "Paste" button from the editing toolbar. And save edits. Voila.