ST_AsEWKT

Introduction: Return the Extended Well-Known Text representation of a geography. EWKT is an extended version of WKT which includes the SRID of the geography. The format originated in PostGIS but is supported by many GIS tools.

Format: ST_AsEWKT (A: Geography)

Return type: String

Since: v1.8.0

SQL Example

SELECT ST_AsEWKT(ST_GeogFromWKT('LINESTRING (1 2, 3 4, 5 6)', 4326))

Output:

SRID=4326; LINESTRING (1 2, 3 4, 5 6)