ST_SetMetaData-AnalyticDB(AnalyticDB)-阿里云帮助中心

Sets or deletes a metadata item on a raster object or one of its bands.

Syntax

(1) Raster-level

raster ST_SetMetaData(raster raster_obj,
                      text key,
                      text value);

(2) Band-level

raster ST_MetaData(raster raster_obj,
                   integer band,
                   text key,
                   text value);

Parameter	Description
`raster_obj`	The raster object whose metadata to update.
`band`	The band to update. Valid values start from 0.
`key`	The metadata key.
`value`	The metadata value.

Setting value to an empty string ('') deletes the metadata item.

SELECT ST_MetaData(ST_SetMetaData(rast, 'NETCDF_DIM_time', '12345'), 'NETCDF_DIM_time')
FROM raster_table

Output:

st_metadata
------------
12345

SELECT ST_MetaData(ST_SetMetaData(rast, 0, 'NETCDF_DIM_time', '12345'), 0, 'NETCDF_DIM_time')
FROM raster_table

Output:

st_metadata
------------
12345