[postgis-users] No extension

[Simon SPDBA Greener]

I can execute spatial queries in pgAdmin 4 OK.

select count(*)
   from df.pit as p
        inner join
        df.path as t
        on (ST_Intersects(t.path_line,ST_Buffer(p.pit_poly,10)))
  where p.pit_id = 50000

count
2

-- 
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w) www.spdba.com.au
(m) simon at spdba.com.au