Name
ST_AsHEXEWKB — Returns the Extended Well-Known Binary (EWKB) representation, in hexadecimal, of a Geometry object.
Synopsis
varchar ST_AsHEXEWKB(bytea
Geometry);
varchar ST_AsHEXEWKB(bytea
Geometry, varchar byteorder
XDR/NDR);
Description
Returns the Extended Well-Known Binary (EWKB) representation, in hexadecimal, of a Geometry object.
The byteorder parameter may be either NDR or XDR. If no encoding is specified, the default value is NDR.
NDR indicates Network Data Representation, also known as little-endian encoding.
XDR represents External Data Representation, also known as big-endian encoding.
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_AsHEXEWKB(ST_GeomFromText('POINT(1 1 1)',25830));
st_ashexewkb
--------------------------------------------------------------------
01010000A0E6640000000000000000F03F000000000000F03F000000000000F03F
(1 row)
SELECT ST_AsHEXEWKB(ST_GeomFromText('POINT(1 1 1)',25830),'XDR');
--Result
00A0000001000064E63FF00000000000003FF00000000000003FF0000000000000