Schema
Owner
postgres
Descriptions
args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
Options
Option | Value |
---|---|
Returns |
boolean |
Language |
|
Parameters |
rastschema name rasttable name rastcolumn name srid boolean = true scale_x boolean = true scale_y boolean = true blocksize_x boolean = true blocksize_y boolean = true same_alignment boolean = true regular_blocking boolean = true num_bands boolean = true pixel_types boolean = true nodata_values boolean = true out_db boolean = true extent boolean = true |
Definition
CREATE OR REPLACE FUNCTION public.droprasterconstraints (
rastschema name,
rasttable name,
rastcolumn name,
srid boolean = true,
scale_x boolean = true,
scale_y boolean = true,
blocksize_x boolean = true,
blocksize_y boolean = true,
same_alignment boolean = true,
regular_blocking boolean = true,
num_bands boolean = true,
pixel_types boolean = true,
nodata_values boolean = true,
out_db boolean = true,
extent boolean = true
)
RETURNS boolean AS
$span$
DECLARE
constraints text[];
BEGIN
IF srid IS TRUE THEN
constraints := constraints || 'srid'::text;
END IF;
IF scale_x IS TRUE THEN
constraints := constraints || 'scale_x'::text;
END IF;
IF scale_y IS TRUE THEN
constraints := constraints || 'scale_y'::text;
END IF;
IF blocksize_x IS TRUE THEN
constraints := constraints || 'blocksize_x'::text;
END IF;
IF blocksize_y IS TRUE THEN
constraints := constraints || 'blocksize_y'::text;
END IF;
IF same_alignment IS TRUE THEN
constraints := constraints || 'same_alignment'::text;
END IF;
IF regular_blocking IS TRUE THEN
constraints := constraints || 'regular_blocking'::text;
END IF;
IF num_bands IS TRUE THEN
constraints := constraints || 'num_bands'::text;
END IF;
IF pixel_types IS TRUE THEN
constraints := constraints || 'pixel_types'::text;
END IF;
IF nodata_values IS TRUE THEN
constraints := constraints || 'nodata_values'::text;
END IF;
IF out_db IS TRUE THEN
constraints := constraints || 'out_db'::text;
END IF;
IF extent IS TRUE THEN
constraints := constraints || 'extent'::text;
END IF;
RETURN DropRasterConstraints($1, $2, $3, VARIADIC constraints);
END;
$span$
LANGUAGE 'plpgsql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;
COMMENT ON FUNCTION public.droprasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean)
IS 'args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |