ST_InterleavingType

更新时间:
复制 MD 格式

Returns the interleaving type of a raster object. The interleaving type indicates how pixel values from multiple bands are arranged in storage: Band Sequential (BSQ), Band Interleaved by Line (BIL), or Band Interleaved by Pixel (BIP).

Syntax

text ST_InterleavingType(raster raster_obj);

Parameters

ParameterDescription
raster_objThe raster object to query.

Return value

Returns a text value indicating the interleaving type. Valid values:

  • BSQ: Band Sequential. All data for each band is stored contiguously before the next band begins.

  • BIL: Band Interleaved by Line. Data is stored one row at a time, cycling through all bands for each row.

  • BIP: Band Interleaved by Pixel. Data is stored one pixel at a time, with all band values for each pixel stored together.

Example

SELECT ST_InterleavingType(raster_obj) FROM raster_table;

Output:

BSQ