ST_GeomFromEWKB constructs a geometry object from the extended well-known binary (EWKB) representation of an input geometry.
ST_GeomFromEWKB accepts 3DZ, 3DM, and 4D geometries written in WKB and EWKB hexadecimal format.
Syntax
ST_GeomFromEWKB(ewkb_string)
Arguments
- ewkb_string
-
A value of data type
VARCHARthat is a hexadecimal EWKB representation of a geometry.
Return type
GEOMETRY
If ewkb_string is null, then null is returned.
If ewkb_string is not valid, then an error is returned.
Examples
The following SQL constructs a polygon from an EWKB value and returns the EWKT representation of a polygon.
SELECT ST_AsEWKT(ST_GeomFromEWKB('0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000'));
st_asewkt
--------------------------------
SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))
