ST_FormatWKT(LONG VARCHAR) method

Returns a formatted copy of the Well Known Text (WKT) definition.

Syntax

ST_SpatialRefSys::ST_FormatWKT(LONG VARCHAR definition)

LONG VARCHAR Returns a text string defining the spatial reference system in WKT.

Example 1 – The following example returns the result GEOGCS["WGS 84", DATUM["WGS_1984", SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]], PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]], UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]], AUTHORITY["EPSG","4326"]].
```
SELECT  ST_SpatialRefSys::ST_FormatWKT('GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]')
```

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension