ALTER OPERATOR CLASS

ALTER OPERATOR CLASS

7

SQL - Language Statements

ALTER OPERATOR CLASS

change the definition of an operator class

ALTER OPERATOR CLASS

name

USING

index\_method

RENAME TO

new\_name

ALTER OPERATOR CLASS

name

USING

index\_method

OWNER TO {

new\_owner

\| CURRENT\_ROLE \| CURRENT\_USER \| SESSION\_USER } ALTER OPERATOR
CLASS

name

USING

index\_method

SET SCHEMA

new\_schema

Description
===========

`ALTER OPERATOR CLASS` changes the definition of an operator class.

You must own the operator class to use `ALTER OPERATOR CLASS`. To alter
the owner, you must also be a direct or indirect member of the new
owning role, and that role must have `CREATE` privilege on the operator
class\'s schema. (These restrictions enforce that altering the owner
doesn\'t do anything you couldn\'t do by dropping and recreating the
operator class. However, a superuser can alter ownership of any operator
class anyway.)

Parameters
==========

name

:   The name (optionally schema-qualified) of an existing operator
    class.

index\_method

:   The name of the index method this operator class is for.

new\_name

:   The new name of the operator class.

new\_owner

:   The new owner of the operator class.

new\_schema

:   The new schema for the operator class.

Compatibility
=============

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

See Also
========
