ST_ExteriorRing

Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon.

Signatures

ST_ExteriorRing(geom: Geometry)

geom

Geometry

required

The input geometry.

The resulting geometry.

SELECT ST_ExteriorRing(ST_GeomFromText('POLYGON((0 0 1, 1 1 1, 1 2 1, 1 1 1, 0 0 1))'))

LINESTRING (0 0, 1 1, 1 2, 1 1, 0 0)

⌘I