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)

Return type: Double

Since: v1.0.0

SQL Example

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

Output:

123.0147027033899