Product Documentation

Appearance

All platforms

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:

Syntax ​

sql
ST_ASEWKB(<input>)

Arguments ​

  • <input>: The GEOGRAPHY object to be converted

Returns ​

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

Example ​

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