Query raster metadata with ST_MetaItems - PolarDB

Returns all customized metadata items for a raster or a specific band.

Syntax

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

Parameters

Parameter	Description
`raster_obj`	The raster to query.
`band`	The band to query. A raster has one or more bands. Band sequence numbers start from 0.

Examples

Query the customized metadata items of a raster:

SELECT ST_MetaItems(raster_obj)
FROM raster_table;

Output:

{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}

Query the customized metadata items of band 0:

SELECT ST_MetaItems(raster_obj, 0)
FROM raster_table;

Output:

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