DropRasterConstraints
Name
DropRasterConstraints — Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
Synopsis
boolean
DropRasterConstraints
(
name
rasttable
, name
rastcolumn
, boolean
srid
, boolean
scale_x
, boolean
scale_y
, boolean
blocksize_x
, boolean
blocksize_y
, boolean
same_alignment
, boolean
regular_blocking
, boolean
num_bands=true
, boolean
pixel_types=true
, boolean
nodata_values=true
, boolean
out_db=true
, boolean
extent=true
)
;
boolean
DropRasterConstraints
(
name
rastschema
, name
rasttable
, name
rastcolumn
, boolean
srid=true
, boolean
scale_x=true
, boolean
scale_y=true
, boolean
blocksize_x=true
, boolean
blocksize_y=true
, boolean
same_alignment=true
, boolean
regular_blocking=false
, boolean
num_bands=true
, boolean
pixel_types=true
, boolean
nodata_values=true
, boolean
out_db=true
, boolean
extent=true
)
;
boolean
DropRasterConstraints
(
name
rastschema
, name
rasttable
, name
rastcolumn
, text[]
constraints
)
;
Description
Drops PostGIS raster constraints that refer to a raster table column that were added by AddRasterConstraints . Useful if you need to load more data or update your raster column data. You do not need to do this if you want to get rid of a raster table or a raster column.
To drop a raster table use the standard
DROP TABLE mytable
To drop just a raster column and leave the rest of the table, use standard SQL
ALTER TABLE mytable DROP COLUMN rast
the table will disappear from the
raster_columns
catalog if the column or table is dropped. However if only the constraints are dropped, the
raster column will still be listed in the
raster_columns
catalog, but there will be no other information about it aside from the column name and table.
Availability: 2.0.0
Examples
SELECT DropRasterConstraints ('myrasters','rast');
----RESULT output ---
t
-- verify change in raster_columns --
SELECT srid, scale_x, scale_y, blocksize_x, blocksize_y, num_bands, pixel_types, nodata_values
FROM raster_columns
WHERE r_table_name = 'myrasters';
srid | scale_x | scale_y | blocksize_x | blocksize_y | num_bands | pixel_types| nodata_values
------+---------+---------+-------------+-------------+-----------+-------------+---------------
0 | | | | | | |