ST_Distance¶

Introduction: Return the minimum geodesic distance between two geographies in meters.

ST_Distance on a sphere: great-circle distance between two geographies

Format:

ST_Distance (geogA: Geography, geogB: Geography)

Return type: Double

Since: v1.9.1

SQL Example:

SELECT ST_Distance(ST_GeogFromWKT('POINT (0 0)', 4326), ST_GeogFromWKT('POINT (0 1)', 4326))

Output:

111195.0662708989