Deletes the pyramid of a raster object, resets its metadata, and removes the associated chunk data.
Syntax
raster ST_deletePyramid(raster source);Parameters
| Parameter | Description |
|---|---|
| source | The raster object whose pyramid, metadata, and chunk data are deleted. |
Description
ST_deletePyramid performs three operations on the specified raster object:
Deletes the pyramid
Resets the metadata
Deletes the chunk data
Example
UPDATE raster_table SET raster_obj = ST_deletePyramid(raster_obj) WHERE id = 1;