ST_GeometryType

Introduction: Returns the type of the geography object as a string (e.g., "ST_Point", "ST_Polygon", "ST_LineString").

Format:

ST_GeometryType (A: Geography)

Return type: String

Since: v1.9.1

SQL Example

SELECT ST_GeometryType(ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'));

Output:

ST_Polygon