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

Constructs a point geometry from a Well-Known Binary (WKB) representation.

Syntax

geometry ST_GeomFromWKB(bytea geom);
geometry ST_GeomFromWKB(bytea geom, integer srid);

Parameter	Description
`geom`	The WKB string that you want to specify.
`srid`	The spatial reference identifier (SRID) to assign to the point geometry. Defaults to `0` if omitted.

If geom does not represent a point geometry, the function returns NULL.
Supports 3D geometries. The Z coordinate of the input is preserved in the returned geometry.
Supports circular strings and curves.

SELECT ST_AsEWKT(ST_GeomFromWKB(E'\\x01010000000000000000c05d400000000000004440'));

Output:

   st_asewkt
---------------
 POINT(119 40)
(1 row)