Navigation :

ST_BandMetaData

ST_BandMetaData
Prev 9.5. Raster Band Accessors Next

Name

ST_BandMetaData — Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.

Synopsis

record ST_BandMetaData ( raster rast , integer bandnum=1 ) ;

Description

Returns basic meta data about a raster band. Columns returned pixeltype | nodatavalue | isoutdb | path.

[Note]

If raster contains no bands then an error is thrown.

[Note]

If band has no NODATA value, nodatavalue will be NULL.

Examples 

SELECT rid, (foo.md).*
 FROM (SELECT rid, ST_BandMetaData(rast,1) As md
FROM dummy_rast WHERE rid=2) As foo;

 rid | pixeltype | nodatavalue | isoutdb | path
-----+-----------+----------------+-------------+---------+------
   2 | 8BUI      |           0 | f       |

See Also

ST_MetaData , ST_BandPixelType

Prev Up Next
ST_WorldToRasterCoordY Home ST_BandNoDataValue