[Qgis-user] Storing data to postgis from Qgis

[David Kramer]

Hi Junior,

It's not as simple as copying data between two tables. If it were purely a
relational db I wouldn't need QGIS, there's a GIS component. Based on a
paper map I have to select a bunch of polygons (think states, regions,
countries, whatever) and use the selection to add new rows to a db table.
Make sense?

Thanks for the reply.
David

On Tue, Dec 30, 2014 at 11:08 AM, Junior Delaz <delazj at gmail.com> wrote:

> Hi,
> It's not (yet) possible to append data to an existing table through
> DBManager.
> i may not understand well your question but What about adding both source
> and destination tables and just select features, copy and paste them from
> the source table to the detination one?
>
> 2014-12-30 17:59 GMT+01:00 David Kramer <davidk at gmail.com>:
>
>>
>>
>> On Tue, Dec 30, 2014 at 5:24 AM, Jan Michálek <godzilalalala at gmail.com>
>> wrote:
>>
>>> In db manager you can import data in new table or add features to an
>>> existing table.
>>> Or you can add empty column to a table, select in qgis desktop, open
>>> atribute table, display selected features on top and edit empty column by
>>> your atributes.
>>>
>>
>> Hi Jan,
>>
>> Sorry I'm not following your explanation of editing attribute table. I
>> know you can db edit tables in QGIS, but I don't see how to get data from a
>> layer to a row of a db via the db manager interface. I see only four action
>> icons (screenshot below) namely "refresh", "SQL window", "import
>> layer/file" and "export to file".
>>
>> [image: Inline image 1]
>>
>> I've been playing around with the import function. I can successfully
>> import a layer into a new table in the db but if I try to import to an
>> existing table it errors out and tells me that the table already exists. I
>> obviously don't want to drop the existing table.
>>
>> Thanks
>> David
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141230/2879ff51/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2014-12-30 at 8.47.02 AM.png
Type: image/png
Size: 14936 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141230/2879ff51/attachment.png>