Return metadata items of a raster using ST_MetaItems - PolarDB

Returns the custom metadata item keys of a raster or a specific band within a raster.

Syntax

text[] ST_metaItems(raster raster_obj)
text[] ST_metaItems(raster raster_obj, integer band)

Parameters

Parameter	Description
`raster_obj`	The raster whose custom metadata items you want to retrieve.
`band`	The band index. A raster has one or more bands, indexed starting from 0.

Examples

Retrieve the custom metadata item keys for an entire raster:

SELECT ST_MetaItems(raster_obj)
FROM raster_table;

Result:

{latitude#long_name,latitude#units,longitude#long_name,longitude#units,NC_GLOBAL#Conventions,NC_GLOBAL#history,NETCDF_DIM_EXTRA,NETCDF_DIM_time_DEF,NETCDF_DIM_time_VALUES}

Retrieve the custom metadata item keys for band 0 of a raster:

SELECT ST_MetaItems(raster_obj, 0)
FROM raster_table;

Result:

{add_offset,long_name,missing_value,NETCDF_DIM_time,NETCDF_VARNAME,scale_factor,units,_FillValue}