ST_MeshGeomFromBinary constructs a meshgeom object from its well-known binary (WKB) representation.
Syntax
meshgeom ST_MeshGeomFromBinary(bytea wkb);
meshgeom ST_MeshGeomFromBinary(bytea wkb, int4 srid);Parameters
| Parameter | Description |
|---|---|
wkt | The WKB representation of the meshgeom object. |
srid | The spatial reference identifier (SRID). |
Example
The following example converts a meshgeom object to WKB using ST_AsBinary, reconstructs it with ST_MeshGeomFromBinary, and returns the result in EWKT format.
SELECT ST_AsEWKT(
ST_MeshGeomFromBinary(
ST_AsBinary(
'MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))'::meshgeom
)
)
);Output:
MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))Related topics
ST_AsBinary: serializes ameshgeomobject to WKB.ST_AsEWKT: serializes ameshgeomobject to well-known text (WKT) or EWKT.
该文章对您有帮助吗？