pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: droprasterconstraints

 

 

Schema

public

 

Owner

albenard

 

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 - 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

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 = 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 (
 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$
SELECT
DropRasterConstraints('', $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.droprasterconstraints(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 - 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 26/02/2014 11:51
Previous topic Chapter index Next topic