Re: [udig-users] Execute an arbitrary SQL query against PostGIS geodatab

[Jody Garnett <jody.garnett@xxxxxxxxx>]

They have recently added some support for direct SQL to the GeoTools library that we use. As of yet nobody has had resources to go look at how to best make use of it.

CQL can do all your spatial functions; what it does not let you do is any kind of "join" between tables. Best advice is to set up a view capturing the join; and then use uDig to show the result.

-- 
Jody Garnett

On Monday, 30 May 2011 at 9:17 PM, LSA wrote:

Mauricio,

unfortunatelly, this is not exactly what I need. PostGis supports SQL extension allowing to write queires like:

SELECT
ST_AsBinary(ff.geom) As wkb
FROM ch01.fastfoods As ff
WHERE EXISTS(SELECT r.gid
FROM ch01.roads As r
WHERE ST_DWithin(ff.geom, r.geom, 1609*10)
AND r.name = 'US Route 1' AND r.state = 'MD'
AND ff.franchise = 'h');

And this extension is what I need.

On the other hand, ECQL is much simpler and allows only to write quieries like:
name = 'US Route 1' AND state = 'MD'.

ECQL will not work for me, because I use OpenJump like 'visual debugger' of the SQL quieries to PostGis database and was thinking about using uDig instead.

Maybe I got you wrong, and Table view somehow allows to execute arbitrary SQL?

Cheers,
Sergey

On 30.05.2011 18:07, Mauricio Pazos wrote:

On Monday, May 30, 2011 12:58:40 PM LSA wrote:

> Thats a pity, it would be convinient...

Hi, maybe I was not clear. It is implemented and you can experiment with it right now!.

It is available in Table view.

cheers

--

Mauricio Pazos

www.axios.es

_______________________________________________
udig-users mailing list
udig-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.refractions.net/mailman/listinfo/udig-users