Skip to main content
Returns MultiGeometry object based on geometry column/s or array with geometries ST_Collect

​
Signatures

ST_Collect(*geom: Geometry)

ST_Collect(geom: ARRAY[Geometry])

​
Parameters

​
geom
Geometry
required
One or more geometry values to collect. Can be passed as individual arguments (variadic) or as an array of geometries.

​
Return type

The resulting geometry.

​
Examples

SELECT ST_Collect(
    ST_GeomFromText('POINT(21.427834 52.042576573)'),
    ST_GeomFromText('POINT(45.342524 56.342354355)')
) AS geom

+---------------------------------------------------------------+
|geom                                                           |
+---------------------------------------------------------------+
|MULTIPOINT ((21.427834 52.042576573), (45.342524 56.342354355))|
+---------------------------------------------------------------+

SELECT ST_Collect(
    Array(
        ST_GeomFromText('POINT(21.427834 52.042576573)'),
        ST_GeomFromText('POINT(45.342524 56.342354355)')
    )
) AS geom

+---------------------------------------------------------------+
|geom                                                           |
+---------------------------------------------------------------+
|MULTIPOINT ((21.427834 52.042576573), (45.342524 56.342354355))|
+---------------------------------------------------------------+