[Qgis-user] Re:Qgis, Postgres Data exchange, Graticule

[Andrea Peri]

I would like to directly get postgres - data into qgis with a few mouse>clicks

>Having Data in a postgres database like:

>Header: Place, Zipcode, number of oaktrees, latitude, longitude, alitude

>Data:     Horn, 32805, 123090, 8.91, 51,87, 270


If I understand your need and if you have installed Postgis.

I think you can try even this way:

using the "RT SQL Layer" plugin you can add this query sql as a layer to the
qgis canvas.

select oid, ST_GeomFromText(''POINT(' || longitude || ' ' || latitude || '
)'');

Regards,



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20100916/b3715c0e/attachment.html>