[postgis-users] test tools

[christomec]

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
>
>