ST_ASEWKB ​

Returns the Extended Well-Known Binary (EWKB) representation of a GEOGRAPHY object, including SRID metadata.

The EWKB format preserves full numeric precision, preventing rounding errors that can occur with text formats such as Well-Known Text (WKT).

See also:

• ST_ASBINARY
• ST_GEOGFROMWKB

Syntax ​

ST_ASEWKB(<input>)

Arguments ​

• <input>: The GEOGRAPHY object to be converted

Returns ​

Returns a VARBINARY containing the EWKB representation of the input GEOGRAPHY.

Example ​

SELECT ST_ASEWKB('POINT(1 1)'::GEOGRAPHY);
-- \x0101000020e6100000000000000000f03f000000000000f03f