[Qgis-user] New PostGIS SQL Query Editor Plugin

[John C. Tull]

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.duester at bd.so.ch
> http://www.agi.so.ch
>
> _______________________________________________
> 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/20090312/c7e2e52e/attachment.html>