I am very new to PostGIS2.4 and Postgresql 10 and having hard times to make holes inside a polygon using another polygon from a single table liveuamap by using
The polygon in the middle should be cleared.
I searched a lot for an answer but nothing could serve in my situation for CARTO. I used the following query :
SELECT a.cartodb_id, b.cartodb_id, CAST (ST_AsText (ST_SymDifference (a.the_geom, b.the_geom) ) AS VARCHAR(350) ) SYM_DIFF FROM liveuamap a, liveuamap b WHERE a.cartodb_id = 105 AND b.cartodb_id = 116