All Products
Search
Document Center

ApsaraDB RDS:ST_SetMetaData

Last Updated:Mar 28, 2026

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

Syntax

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

Parameters

Parameter name

Description

raster_obj

The raster whose metadata item you want to specify.

band

The sequence number of the band whose metadata item you want to specify. Valid values start from 0.

key

The name of the metadata item.

value

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

Examples

Set and retrieve a raster-level metadata item:

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

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

Set and retrieve a band-level metadata item on band 0:

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

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