This function deletes a pyramid for a raster object.
Syntax
raster ST_deletePyramid(raster source);
Parameters
Parameter | Description |
---|---|
source | The raster object. |
Description
This function deletes the pyramid, resets the metadata, and deletes the chunk data for the raster object.
Examples
DO $$
declare
rast raster;
begin
select raster_obj into rast from raster_table where id = 1;
rast = ST_deletePyramid(rast);
update raster_table set raster_obj = rast where id = 1;
end;
$$ LANGUAGE 'plpgsql';