<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Düster,<div><br></div><div>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?</div><div><br></div><div>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? </div><div><br></div><div>Cheers,</div><div>John</div><div><br><div><div>On Mar 12, 2009, at 1:36 AM, Düster Horst wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">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.</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">I hope that the plugin will be helpful for you. I'm looking forward for any comment.</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">Regards</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">Dr. Horst Düster</span><br><span style="font-size: 10pt; ">Stv. Amtschef / GIS-Koordinator</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">Kanton Solothurn</span><br><span style="font-size: 10pt; ">Bau- und Justizdepartement</span><br><span style="font-size: 10pt; ">Amt für Geoinformation</span><br><span style="font-size: 10pt; ">SO!GIS Koordination</span><br><span style="font-size: 10pt; ">Rötistrasse 4</span><br><span style="font-size: 10pt; ">CH-4501 Solothurn</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; ">Telefon ++41(0)32 627 25 32</span><br><span style="font-size: 10pt; ">Telefax ++41(0)32 627 22 14</span></div><br><div class="Normal" style="text-align: left; text-indent: 0pt; margin-top: 0pt; margin-bottom: 0pt; font-family: Arial; font-size: 12pt; "><span style="font-size: 10pt; "><a href="mailto:horst.duester@bd.so.ch">mailto:horst.duester@bd.so.ch</a></span><br><span style="font-size: 10pt; "><a href="http://www.agi.so.ch">http://www.agi.so.ch</a></span></div><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></div></span></blockquote></div><br></div></body></html>