ST_InterleavingType
Updated at:
Copy as MD
ST_InterleavingType returns the interleaving type of a raster object. The interleaving type describes how pixel data is organized on disk, which affects read performance and compatibility with downstream processing tools. The return value is one of three formats: BSQ (Band Sequential), BIL (Band Interleaved by Line), or BIP (Band Interleaved by Pixel).
Syntax
text ST_InterleavingType(raster raster_obj);Parameters
| Parameter | Description |
|---|---|
raster_obj | The raster object whose interleaving type is queried. |
Return value
One of the following values:
| Value | Full name |
|---|---|
BSQ | Band Sequential |
BIL | Band Interleaved by Line |
BIP | Band Interleaved by Pixel |
Examples
Query the interleaving type of all raster objects in a table:
SELECT ST_InterleavingType(raster_obj) FROM raster_table;Expected output:
BSQIs this page helpful?