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 ]