ST_Length

Introduction: Returns the perimeter of A.

Warning

Since v1.7.0, this function only supports LineString, MultiLineString, and GeometryCollections containing linear geometries. Use ST_Perimeter for polygons.

Format: ST_Length (A: Geometry)

Since: v1.3.0

Example:

SELECT ST_Length(ST_GeomFromWKT('LINESTRING(38 16,38 50,65 50,66 16,38 16)'))

Output:

123.0147027033899