[postgis-users] test tools
schabi at logix-tt.com
Tue Oct 25 04:48:27 PDT 2005
> Are there any tools available for visually testing my queries?
> I thought that qgis would do the trick but is seems that you can only add
> a where clause. I need to be able to run my custom queries to see exactly
> what I query especially with functions like intersection.
Maybe Thuban or uDIG do what you want.
Another trick may be to create a view for your query, and add a fake
geometry_columns entry for it. This way, the most GIS tools can display
arbitrarily complex queries like a simple table.
(Maybe you need to expose or fake a OID column for some of those tools,
and write support is a more complicated work using SQL Rules, but we've
done this inhouse already.)
More information about the postgis-users