ST_Update

Updates a destination raster object with data from a source raster object.

Syntax

raster ST_Update(raster source, raster dest);

Parameter	Description
`source`	The source raster object whose data is written into the destination.
`dest`	The destination raster object to be updated.

The following example updates the raster object with id=1 using the raster object with id=2 as the source.

UPDATE raster_table
SET raster_obj = ST_Update(raster_obj, (SELECT raster_obj FROM raster_table WHERE id = 2))
WHERE id = 1;