ST_GeomFromEWKT

ST_GeomFromEWKT
Prev	2. Geometry Constructors	Next

Name

ST_GeomFromEWKT — Return a specified Geometry from a Extended Well-Known Text representation (EWKT)

Synopsis

geometry ST_GeomFromEWKT(varchar EWKT);

Alias

GeomFromEWKT

Description

Return a specified Geometry from a Extended Well-Known Text representation (EWKT). The EWKB format is a Postgis format that adds the Spatial Reference ID (SRID) to the OGC Well-Known Text representation (WKT).


	The reverse function is ST_AsEWKT

Coordinate Dimensions

2D	3D	M

Spatial Standards Support

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
-	-	-	-

Examples

PostgreSQL

SELECT ST_GeomFromEWKT('SRID=25830;POINT(5 5)') as Point;

--Result
                                        point                                         
--------------------------------------------------------------------------------------
 \011 \200\346d\000\000\001\000\000\000\000\000\000\024@\000\000\000\000\000\000\024@
(1 row)

H2

SELECT ST_GeomFromEWKT('SRID=25830;POINT(5 5)') as Point;

--Result
POINT  
092080e66400000100000000000014400000000000001440

Related functions

ST_AsEWKT, ST_GeomFromText