Skip to content

ST_GEOGFROMWKB

Creates a GEOGRAPHY object from a Well-Known Binary (WKB) or Extended WKB (EWKB) representation.

This function is automatically invoked when casting a VARBINARY to GEOGRAPHY.

See also:

Syntax

sql
ST_GEOGFROMWKB(<input>)

Arguments

  • <input>: A WKB or EWKB formatted type in VARBINARY

Returns

A GEOGRAPHY type represented by the input WKB/EWKB format

Example

sql
SELECT ST_GeogFromWKB('\x0101000000000000000000f03f000000000000f03f'::VARBINARY);
-- 'POINT(1 1)'