ST_ForceCollection

Syntax

geometry ST_ForceCollection(geometry geomA);

Parameters

Description

ST_ForceCollection wraps any geometry type in a GeometryCollection, simplifying its Well-Known Binary (WKB) representation.

• Supports circular strings, curves, and polyhedral surfaces.

• Supports 3D objects and retains z coordinates.

Examples

Convert a polygon

SELECT ST_AsText(ST_ForceCollection(ST_GeomFromText('POLYGON((1 1,2 1,2 2,1 2,1 1))')));

Output:

                     st_astext
----------------------------------------------------
 GEOMETRYCOLLECTION(POLYGON((1 1,2 1,2 2,1 2,1 1)))
(1 row)