Schema
Owner
postgres
Descriptions
args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice.
Options
Option | Value |
---|---|
Returns |
boolean |
Language |
sql |
Parameters |
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 = false 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.addrasterconstraints (
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 = false,
num_bands boolean = true,
pixel_types boolean = true,
nodata_values boolean = true,
out_db boolean = true,
extent boolean = true
)
RETURNS boolean AS
$span$
SELECT public.AddRasterConstraints('', $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
$span$
LANGUAGE 'sql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;
COMMENT ON FUNCTION public.addrasterconstraints(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: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |