This function uses a raster object or object set to update an overview.


raster ST_UpdateOverview(raster raster_obj,raster source[]);


Parameter Description
raster_obj The destination raster object.
source The source raster object or object set.


All the specified raster objects must meet the following requirements:
  • They have the same number of bands.
  • Either all of them are geographically referenced, or none of them is geographically referenced. If all of them are geographically referenced, world coordinates (geographic coordinates) are used for the mosaic operation.
  • Their pixel types can be different. If world coordinates are used for the mosaic operation, they must have the same spatial reference system identifier (SRID) and pixel resolution.


Update raster_table set raster_obj = ST_UpdateOverview(raster_obj, Array(select raster_obj from raster_table_new)) where id = 1;