Hi David,
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.
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.
Brent Wood
From: David Kramer <dav...@gmail.com>
To: Leknín Řepánek <godzilalal...@gmail.com>
Cc: qgis-user <qgis-user@lists.osgeo.org>
Sent: Tuesday, December 30, 2014 6:10 PM
Subject: Re: [Qgis-user] Storing data to postgis from Qgis
Leknin,
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.
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:
'Franchise Name' | 'States' |
'geom'===================================Alice's Restaurant | "NY, NJ, PA"
| ...
Joe's Burgers | "CA, NV, OR" | ...
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.
Make sense? Is this possible from the GUI or do I need to write a plugin in
pyQGIS?
Thx
David
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
