ST_GeogFromWKB-PolarDB(PolarDB)-阿里云帮助中心

Parses a Well-Known Binary (WKB) or Extended Well-Known Binary (EWKB) input and returns a geography value.

Syntax

geography ST_GeogFromWKB(bytea wkb);

Parameter	Description
`wkb`	A `bytea` value in WKB or EWKB format. In PostgreSQL, pass a binary literal using the escape syntax: `E'\\x<hex>'`, where `<hex>` is the hexadecimal representation of the geometry without a leading `0x`.

If no spatial reference identifier (SRID) is embedded in the input, the default SRID 4326 is used.
Supports circular strings and curves.

Convert a WKB-encoded point to its text representation:

SELECT ST_AsText(ST_GeogFromWKB(E'\\x01010000000000000000005d400000000000004440'));

Output:

   st_astext
---------------
 POINT(116 40)
(1 row)

ST_GeogFromText: Construct a geography object from a Well-Known Text (WKT) or EWKT string.
ST_AsBinary: Convert a geometry or geography value back to WKB format.