ST_AsHexWKB
ST_AsHexWKB returns the hexadecimal well-known binary (WKB) representation of an input geometry or geography using ASCII hexadecimal characters (0–9, A–F). For 3DZ, 3DM, and 4D geometries or geographies, ST_AsHexWKB uses the Open Geospatial Consortium (OGC) standard value for the geometry or geography type.
Syntax
ST_AsHexWKB(geo)
Arguments
- geo
-
A value of data type
GEOMETRY
orGEOGRAPHY
, or an expression that evaluates to aGEOMETRY
orGEOGRAPHY
type.
Return type
VARCHAR
If geo is null, then null is returned.
If the result is larger than a 64-KB VARCHAR
, then an error is
returned.
Examples
The following SQL returns the hexadecimal WKB representation of a polygon in a geometry.
SELECT ST_AsHexWKB(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));
st_ashexwkb
--------------------------------
01030000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000
The following SQL returns the hexadecimal WKB representation of a polygon in a geography.
SELECT ST_AsHexWKB(ST_GeogFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))'));
st_ashexwkb
--------------------------------
01030000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000