I have a multipolygon with two parts:
I want to erase the line that separate both parts and get a single polygon that looks like this:
I don't mind if I do it in QGIS or in Postgis, but it has to be only for this multipolygon.
I have read similar posts that suggest a solution to the problem but I had no success so far. I read and tried this, this and this.
I tried postgis functions like ST_Dump, ST_Collect, ST_ConvexHull, St_Union, ST_ExteriorRing, ST_Boundary, etc in SQLs like:
update my_table set the_geom = ST_Boundary(st_snaptogrid(the_geom,0.0001)) where id=3173
I don't really know which is the right approach to achieve this.
PD: If I do ST_NumGeometries I obviously get 2 geometries.