> ## 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.

# ST_Dump

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.

<img src="https://mintcdn.com/wherobots/fqh3gPDE0J25Lra_/images/sql-functions/ST_Dump/ST_Dump.svg?fit=max&auto=format&n=fqh3gPDE0J25Lra_&q=85&s=88734bc01466cedb26747f30c6b20e40" alt="ST_Dump" width="500" height="300" data-path="images/sql-functions/ST_Dump/ST_Dump.svg" />

## Signatures

```sql theme={"system"}
ST_Dump(geom: Geometry)
```

## Parameters

<ParamField body="geom" type="Geometry" required>
  The input geometry.
</ParamField>

## Return type

<ResponseField type="Array<Geometry>">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
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)]
```