ST_UpdateOverview
Updated at:
Updates the overview of a destination raster object using one or more source raster objects.
Syntax
raster ST_UpdateOverview(raster raster_obj, raster source[]);Parameters
| Parameter | Description |
|---|---|
raster_obj | The destination raster object. |
source | The source raster object or object set. |
Description
All raster objects passed to this function must meet the following requirements:
They have the same number of bands.
Either all of them are georeferenced, or none of them is georeferenced. If all are georeferenced, world coordinates (geographic coordinates) are used for the mosaic operation.
Pixel types can differ. If world coordinates are used for the mosaic operation, all raster objects must share the same spatial reference system identifier (SRID) and pixel resolution.
Examples
Update raster_table set raster_obj = ST_UpdateOverview(raster_obj, Array(select raster_obj from raster_table_new)) where id = 1;Is this page helpful?