ST_AsEWKT

ST_AsEWKT
Prev	5. Geometry Outputs	Next

Name

ST_AsEWKT — Returns the Extended Well-Known Text representation (EWKT) from a geometry object.

Synopsis

varchar ST_AsEWKT(bytea Geometry);

Alias

AsEWKT

Description

Returns the Extended Well-Known Text (EWKT) representation of a Geometry object. The EWKT 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_GeomFromEWKT

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

SELECT ST_AsEWKT(ST_GeomFromText('POINT(1 1 1)',25830));

--Result
SRID=25830;POINT (1 1 1)

Related functions

ST_GeomFromEWKT, ST_AsText

Prev	Up	Next
ST_AsEWKB	Home	ST_AsHEXEWKB