PostGIS Query Editor Plugin
You can install the plugin with the QGIS Plugin-Installer or download it from http://www.kappasys.ch/qgis/postgisquery.zip
The plugin offers a SQL query editor, performs the edited spatial PostGIS queries and visualises the query result as shape in MapCanvas.
The Path to pgsql2shp must be added to the system PATH environment.
If you start the PostGIS Query Editor for the first time you have to define the path to a directory where the resultand shape files will be stored. You can change this path later if you want.
Running a Query:
You can run queries in two ways:
1. Click the Run button
2. Hit the F5 key on your keyboard
Running a part of your query:
It is possible to run only parts of your edited query. To do this you have to select the part of the query with the cursor and then hit F5 or click Run.
Persistance of Queries:
The edited query will persist for multiple session until you click the Clear button.
Save and load Queries:
The Save and Load button saves or loads your queries to or from files.
PostGIS Query Editor is copyright (C) 2009 Dr. Horst Düster
If you would like to report a bug, make suggestions for improving PostGIS Query Editor, or have a question about the editor, please email me: firstname.lastname@example.org
licensed under the terms of GNU GPL 2
This program is free software; you can redistribute it and/or modifyit under the terms of the GNU General Public License as published bythe Free Software Foundation; either version 2 of the License, or(at your option) any later version.
This program is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See theGNU General Public License for more details.
You should have received a copy of the GNU General Public License alongwith this program; if not, write to the Free Software Foundation, Inc.,51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.