All Products
Search
Document Center

PolarDB:ST_MeshGeomFromWKT

Last Updated:Mar 28, 2026

Constructs a meshgeom object from its Well-Known Text (WKT) representation.

Syntax

meshgeom ST_MeshGeomFromWKT(text wkt);
meshgeom ST_MeshGeomFromWKT(text wkt, int4 srid);

Parameters

ParameterDescription
wktThe WKT representation of the meshgeom object.
sridThe spatial reference identifier (SRID).

Description

ST_MeshGeomFromWKT parses a WKT string and returns a meshgeom object.

Example

The following example constructs a meshgeom object from a WKT string with SRID 4326, then retrieves its EWKT representation using ST_AsEWKT.

SELECT ST_AsEWKT(
  ST_MeshGeomFromWKT(
    'MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))',
    4326
  )
);

Output:

SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))