ST_WKTToSQL — Return a geometric object given its Well-known text Representation. This is an alias for ST_GeomFromText.
geometry ST_WKTToSQL(varchar WKT, integer
SRID);
geometry ST_WKTToSQL(varchar WKT);
The ST_WKTToSQL function takes a geometry textual representation and a Spatial Reference System ID (SRID) and creates an instance of the appropriate Geometry Type. If the SRID is not provided it defaults to -1.
| 2D | 3D | M |
|---|---|---|
![]() | ![]() | ![]() |
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
|---|---|---|---|
| - | - | - | 5.1.34 |