[postgis-users] st_union

Paul Ramsey pramsey at cleverelephant.ca
Mon Mar 2 09:03:30 PST 2020


No, if it’s returning the answer you want, that’s the way to do it, and there’s no way around it. 

> On Mar 2, 2020, at 6:25 AM, <paul.malm at lfv.se> <paul.malm at lfv.se> wrote:
> 
> Hi list,
> I would like to do this:
> CREATE TABLE public."Areas_union" AS select  (st_dump(st_union("the_geom"))).geom from "Areas";
>  
> But it takes such a long time to execute, is there a smarter way to do it?
>  
> Kind regards,
> Paul
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



More information about the postgis-users mailing list