wehub-resource-sync
45 lines
1.7 KiB
Plaintext
45 lines
1.7 KiB
Plaintext
ALTER EXTENSION $name$ UPDATE [ TO $new_version$ ]
|
|
|
|
ALTER EXTENSION $name$ SET SCHEMA $new_schema$
|
|
|
|
ALTER EXTENSION $name$ ADD $member_object$
|
|
|
|
ALTER EXTENSION $name$ DROP $member_object$
|
|
|
|
where $member_object$ is:
|
|
|
|
ACCESS METHOD $object_name$ |
|
|
AGGREGATE $aggregate_name$ ( $aggregate_signature$ ) |
|
|
CAST ($source_type$ AS $target_type$) |
|
|
COLLATION $object_name$ |
|
|
CONVERSION $object_name$ |
|
|
DOMAIN $object_name$ |
|
|
EVENT TRIGGER $object_name$ |
|
|
FOREIGN DATA WRAPPER $object_name$ |
|
|
FOREIGN TABLE $object_name$ |
|
|
FUNCTION $function_name$ [ ( [ { [ $routine_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ] ] ) ] |
|
|
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$ |
|
|
PROCEDURE $procedure_name$ [ ( [ { [ $routine_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ] ] ) ] |
|
|
ROUTINE $routine_name$ [ ( [ { [ $routine_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ] ] ) ] |
|
|
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$ |
|
|
TRANSFORM FOR $type_name$ LANGUAGE $lang_name$ |
|
|
TYPE $object_name$ |
|
|
VIEW $object_name$
|
|
|
|
where $aggregate_signature$ is:
|
|
|
|
* |
|
|
{ [ $agg_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ] |
|
|
[ { [ $agg_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ] ] ORDER BY { [ $agg_argmode$ ] [ $argname$ ] $argtype$ } [ , ... ]
|