<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1419893908255_67185"><span></span></div><div id="yui_3_16_0_1_1419893908255_67188">Hi David,</div><div id="yui_3_16_0_1_1419893908255_67190" dir="ltr"><br>I'm not sure why you are trying to do that from QGIS, given you can do it all from Postgis directly, especially given your data is already in a database, without the mapping/GUI overhead... nothing you have suggested as a means of selecting data subsets requires QGIS. <br></div><div id="yui_3_16_0_1_1419893908255_67191" dir="ltr"><br></div><div id="yui_3_16_0_1_1419893908255_67193" dir="ltr">However, as I read it, at least some of what you are trying to do could also be done via a QGIS action, as a system call with SQL statements & data parameters, especially with known table names, etc.</div><div id="yui_3_16_0_1_1419893908255_67194" dir="ltr"><br></div><div id="yui_3_16_0_1_1419893908255_67647" dir="ltr">Brent Wood<br></div><div id="yui_3_16_0_1_1419893908255_68109" dir="ltr"><br></div><div id="yui_3_16_0_1_1419893908255_68576" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1419893908255_68575" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1419893908255_68574" dir="ltr"> <hr size="1"> <font id="yui_3_16_0_1_1419893908255_68573" size="2" face="Arial"> <b id="yui_3_16_0_1_1419893908255_68572"><span id="yui_3_16_0_1_1419893908255_68571" style="font-weight:bold;">From:</span></b> David Kramer <davidk@gmail.com><br> <b id="yui_3_16_0_1_1419893908255_68578"><span id="yui_3_16_0_1_1419893908255_68577" style="font-weight: bold;">To:</span></b> Leknín Řepánek <godzilalalala@gmail.com> <br><b id="yui_3_16_0_1_1419893908255_68580"><span id="yui_3_16_0_1_1419893908255_68579" style="font-weight: bold;">Cc:</span></b> qgis-user <qgis-user@lists.osgeo.org> <br> <b id="yui_3_16_0_1_1419893908255_68582"><span id="yui_3_16_0_1_1419893908255_68581" style="font-weight: bold;">Sent:</span></b> Tuesday, December 30, 2014 6:10 PM<br> <b id="yui_3_16_0_1_1419893908255_68584"><span id="yui_3_16_0_1_1419893908255_68583" style="font-weight: bold;">Subject:</span></b> Re: [Qgis-user] Storing data to postgis from Qgis<br> </font> </div> <div id="yui_3_16_0_1_1419893908255_68585" class="y_msg_container"><br><div id="yiv8206912375"><div id="yui_3_16_0_1_1419893908255_68588"><div id="yui_3_16_0_1_1419893908255_68587" dir="ltr"><div id="yui_3_16_0_1_1419893908255_68586" class="yiv8206912375gmail_extra">Leknin, </div><div id="yui_3_16_0_1_1419893908255_68589" class="yiv8206912375gmail_extra"><br clear="none"></div><div id="yui_3_16_0_1_1419893908255_68590" class="yiv8206912375gmail_extra">Thanks for the reply. I've followed your recipe and indeed I can paste my selected features as a new memory layer (thanks Jan) and then import the layer via db manager into postgis. This is tremendously useful, but is not quite what I'm looking for.</div><div class="yiv8206912375gmail_extra"><br clear="none"></div><div class="yiv8206912375gmail_extra">I don't really want to create a new table, I really want to just select a few fields out of my newly selected layer and save those as a row in an already created table. For example, let's assume I have a table that lists franchises the states that they do business in and the columns:</div><div class="yiv8206912375gmail_extra"><br clear="none"></div><div class="yiv8206912375gmail_extra">'Franchise Name' | 'States' | 'geom'</div><div class="yiv8206912375gmail_extra">===================================</div><div class="yiv8206912375gmail_extra">Alice's Restaurant | "NY, NJ, PA" | ...<br clear="none"></div><div class="yiv8206912375gmail_extra">Joe's Burgers | "CA, NV, OR" | ...</div><div class="yiv8206912375gmail_extra"><br clear="none"></div><div class="yiv8206912375gmail_extra">To add a new row to the table I'd like to go into qgis, select the states for a franchise (from a layer of states), save that as a memory layer. Then I'd like to have a save function which allows me to enter the franchise name. It would save only the name, the states and the geometry as a row in the table. </div><div class="yiv8206912375gmail_extra"><br clear="none"></div><div class="yiv8206912375gmail_extra">Make sense? Is this possible from the GUI or do I need to write a plugin in pyQGIS?</div><div class="yiv8206912375gmail_extra"><br clear="none"></div><div class="yiv8206912375gmail_extra">Thx</div><div class="qtdSeparateBR"><br><br></div><div class="yiv8206912375yqt4443646826" id="yiv8206912375yqtfd27339"><div class="yiv8206912375gmail_extra">David</div></div></div></div></div><br><div class="yqt4443646826" id="yqtfd48281">_______________________________________________<br clear="none">Qgis-user mailing list<br clear="none"><a shape="rect" ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br clear="none"><a shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div><br><br></div> </div> </div> </div></body></html>