[postgis-users] test tools

christomec christo at mecola.com
Tue Oct 25 05:39:04 PDT 2005

Thanx, I'll give it a try.

I was aware of the 'create a view' solution, it just seems like allot of
effort to go through every time I want to test a query.

> Hi, Christomec,
> christomec wrote:
>> 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.)
> HTH,
> Markus
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list