title: PostGIS - Merge buffers geometry in different groups (when intersecting)
body: <p>I've  some geometries stored in this table (140k)</p>
  
  <blockquote>
    <p>CREATE TABLE buffers (pk integer NOT NULL,geom geometry(MultiPolygon,4326),)</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/LVb99.png" alt="- buffers geometries from table &quot;buffers&quot; -"></p>
  
  <p>and i would like to create (if possible) a new table (buffersmerged) that will contain the resultants geometries where the previews are <strong>grouped</strong> just when them are <strong>intersecting</strong> between each other. </p>
  
  <p>My expected output, it is like when using in QGIS the Buffer(s) tool checking on "dissolve buffer results", but i would like, rather than just a big unique geometry as output, more small groups (one for each group of intersecting geometries)</p>
  
  <p><img src="https://i.stack.imgur.com/6Ns63.png" alt="- this is the expected result -"></p>
  
  <p>can you please help me to understand how can I construct a query that allows me to do that? (Postgres + PostGIS enabled)
  Thank You </p>
  
  <p>Stefano</p>