Database Reference
In-Depth Information
aggregate_type : This is an input data type on which the aggregate
functions operate
source_type and target_type : These are the name of the source and target
data types of the cast
argmode : This is the mode of a function argument, that is, IN , OUT , INOUT , or
VARIADIC . If omitted, the default mode is IN
argname : This is the name of a function argument
argtype : This is the data type(s) of the function's arguments
left_type , right_type : These are the data type(s) of the operator's
arguments
PROCEDURAL : This is a noise word. Noise words are keywords/reserved
words that are optional in the program and if not implemented, will still
make the program run
Let's try to update the adminpack extension to version 2.0. using the
following statement:
warehouse_db=# ALTER EXTENSION adminpack UPDATE TO '2.0';
You will get an error if your PostgreSQL's installation does not have 2.0 for
adminpack .
If the user wants to change the schema of the adminpack extension to another
schema and the a dminpack extension supports SET SCHEMA , then the following
command is used:
ALTER EXTENSION adminpack SET SCHEMA schema_name;
If the user wants to add an existing function to the adminpack extension, then using
the following command can do it:
ALTER EXTENSION adminpack ADD FUNCTION
function_name(anyelement, anytype);
Dropping extensions
To drop the extension, the user can use the following command:
DROP EXTENSION [IF EXISTS] extension_name [, ...]
[ CASCADE | RESTRICT ]
 
Search WWH ::




Custom Search