Database Reference
In-Depth Information
MATERIALIZED VIEW object_name |
OPERATOR operator_name (left_type, right_type) |
OPERATOR CLASS object_name USING index_method |
OPERATOR FAMILY object_name USING index_method |
[PROCEDURAL ] LANGUAGE object_name |
SCHEMA object_name |
SEQUENCE object_name |
SERVER object_name |
TABLE object_name |
TEXT SEARCH CONFIGURATION object_name |
TEXT SEARCH DICTIONARY object_name |
TEXT SEARCH PARSER object_name |
TEXT SEARCH TEMPLATE object_name |
TYPE object_name |
VIEW object_name
And
aggregate_signature
is:
[ argmode ] [ argname ] argtype [ , ... ] |
[ [ argmode ] [ argname ] argtype [ ,..] ] ORDER BY [ argmode ]
[ argname ] argtype [ ,.. ]
For more details we can refer to
http://www.postgresql.org/
docs/9.4/static/sql-alterextension.html
.
Let's describe the parameter used in the
ALTER EXTENSION
command:
•
Extension_name
: This is the name of an installed extension
•
UPDATE
: This will update the extension to a newer version
•
SET SCHEMA
: This will move the extension objects into another schema
•
ADD member_object
: This will add an existing object to the extension
•
DROP member_object
: This will remove a member object from the extension
Only owners of the extension or a superuser can alter
an extension.
•
new_version
: This gives the new version of the extension
•
new_schema
: This gives the new schema for the extension
•
object_name
,
aggregate_name
,
function_name
, and
operator_name
:
These are the names of objects to be added to or removed from the extension