Query custom tile options with ST_TileOption - PolarDB

Returns the tile configuration options of an sfmesh object as a JSON string.

Syntax

cstring ST_TileOption(sfmesh sfmesh);

Parameter	Description
`sfmesh`	The sfmesh object to query.

A JSON string containing the following fields. Set these values in advance using ST_SetTileOption.

Field	Description
`with_geometry`	Whether geometry objects are included in the tile. `true` includes geometry objects; `false` excludes them.
`with_submesh`	Whether child sfmesh objects are included in the tile. `true` includes child sfmesh objects; `false` excludes them.

{
  "with_geometry": true,
  "with_submesh": true
}

The following example queries the tile options of the the_mesh column (type sfmesh) from t_table.

SELECT ST_TileOption(the_mesh)
FROM t_table;

Output:

-------------------
{"with_geometry":true,"with_submesh":true}