ST_Dump¶

Introduction: It expands the geometries. If the geometry is simple (Point, Polygon Linestring etc.) it returns the geometry itself, if the geometry is collection or multi it returns record for each of collection components.

ST_Dump

Format: ST_Dump(geom: Geometry)

Return type: Array<Geometry>

Since: v1.5.0

Example:

SELECT ST_Dump(ST_GeomFromText('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'))

Output:

[POINT (10 40), POINT (40 30), POINT (20 20), POINT (30 10)]