Düster,

Do you have any documentation on how to use this? I gave it a go this morning, but a simple query statement did not work. What would be a snippet that would work in the query editor given that one has a table called "example" in a database called postgis with public schema on a local server?

Also, the plugin asks for a temporary directory to store files in, but it seems that you need a permanent directory to work from. This is where I am confused. Is this meant to perform queries on existing postgis tables, or is it meant to query a shapefile and then load it into postgis? If the former, how does it improve on adding a postgis layer and performing the query there?

Cheers,
John

On Mar 12, 2009, at 1:36 AM, Düster Horst wrote:

I just uploaded the new PostGIS SQL Query Editor Plugin to the QGIS User-Contributed Python Plugin Repository. The aim of the plugin is to edit and perform any spatial PostGIS query from an editor environment. After successful execution of a query the result will be loaded from shape file to MapCanvas. The plugin works provided that pgsql2shp is installed and the path to pgsql2shp is defined in the system PATH environment.

I hope that the plugin will be helpful for you. I'm looking forward for any comment.

Regards

Dr. Horst Düster
Stv. Amtschef / GIS-Koordinator

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn

Telefon ++41(0)32 627 25 32
Telefax ++41(0)32 627 22 14

mailto:horst.dues...@bd.so.ch
http://www.agi.so.ch

_______________________________________________
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

Reply via email to