1ALTER OPERATOR CLASS(7)          SQL Commands          ALTER OPERATOR CLASS(7)
2
3
4

NAME

6       ALTER OPERATOR CLASS - change the definition of an operator class
7
8

SYNOPSIS

10       ALTER OPERATOR CLASS name USING index_method RENAME TO newname
11       ALTER OPERATOR CLASS name USING index_method OWNER TO newowner
12
13

DESCRIPTION

15       ALTER OPERATOR CLASS changes the definition of an operator class.
16
17       You  must own the operator class to use ALTER OPERATOR CLASS.  To alter
18       the owner, you must also be a direct or indirect member of the new own‐
19       ing  role,  and  that  role  must have CREATE privilege on the operator
20       class's schema. (These restrictions enforce  that  altering  the  owner
21       doesn't  do  anything  you  couldn't  do by dropping and recreating the
22       operator class. However, a superuser can alter ownership of any  opera‐
23       tor class anyway.)
24

PARAMETERS

26       name   The  name  (optionally schema-qualified) of an existing operator
27              class.
28
29       index_method
30              The name of the index method this operator class is for.
31
32       newname
33              The new name of the operator class.
34
35       newowner
36              The new owner of the operator class.
37

COMPATIBILITY

39       There is no ALTER OPERATOR CLASS statement in the SQL standard.
40

SEE ALSO

42       CREATE OPERATOR CLASS [create_operator_class(7)], DROP  OPERATOR  CLASS
43       [drop_operator_class(7)],  ALTER  OPERATOR  FAMILY [alter_operator_fam‐
44       ily(7)]
45
46
47
48SQL - Language Statements         2011-09-22           ALTER OPERATOR CLASS(7)