ST_GeometryFromText-ApsaraDB RDS(RDS)-阿里云帮助中心

Constructs a geometry object from a Well-Known Text (WKT) string.

Syntax

geometry ST_GeometryFromText(text WKT);
geometry ST_GeometryFromText(text WKT, integer srid);

Parameters

Parameter	Description
WKT	The WKT string that you want to specify.
srid	The spatial reference identifier (SRID) of the geometry object.

Description

Supports circular strings and curves.
Equivalent to the ST_GeomFromText function.

Examples

Construct a geometry object using the default parameter settings.

SELECT ST_GeomFromText('POINT(116 40)');
              st_geomfromtext
--------------------------------------------
 01010000000000000000005D400000000000004440
(1 row)

Construct a geometry object using a specified SRID.

SELECT ST_GeomFromText('POINT(116 40)',4326);
                  st_geomfromtext
----------------------------------------------------
 0101000020E61000000000000000005D400000000000004440
(1 row)