ST_GeomFromWKB

Construct a Geometry from WKB string or Binary. This function also supports EWKB format.

Signatures

ST_GeomFromWKB (Wkb: String)

ST_GeomFromWKB (Wkb: Binary)

Wkb

String

required

A Well-Known Binary (WKB) representation of a geometry.

The resulting geometry.

SELECT ST_GeomFromWKB([01 02 00 00 00 02 00 00 00 00 00 00 00 84 D6 00 C0 00 00 00 00 80 B5 D6 BF 00 00 00 60 E1 EF F7 BF 00 00 00 80 07 5D E5 BF])

LINESTRING (-2.1047439575195312 -0.354827880859375, -1.49606454372406 -0.6676061153411865)

SELECT ST_asEWKT(ST_GeomFromWKB('01010000a0e6100000000000000000f03f000000000000f03f000000000000f03f'))

SRID=4326;POINT Z(1 1 1)

⌘I