Skip to main content
Construct a Point geometry from WKB string or Binary and an optional SRID. This function also supports EWKB format.
Returns null if geometry is not of type Point.

Signatures

ST_PointFromWKB (Wkb: String)
ST_PointFromWKB (Wkb: Binary)
ST_PointFromWKB (Wkb: String, srid: Integer)
ST_PointFromWKB (Wkb: Binary, srid: Integer)

Parameters

Wkb
String
required
A Well-Known Binary (WKB) representation of a geometry.
srid
Integer
Spatial Reference Identifier.

Return type

The resulting geometry.

Example

SELECT ST_PointFromWKB([01 01 00 00 00 00 00 00 00 00 00 24 40 00 00 00 00 00 00 2e 40])
POINT (10 15)