Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt

Use this file to discover all available pages before exploring further.

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

​
Signatures

ST_Dump(geom: Geometry)

​
Parameters

​
geom
Geometry
required
The input geometry.

​
Return type

The resulting geometry.

​
Example

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

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