↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
Historical version. PostgreSQL 8.0 has reached end of support. See the current manual.

ALTER OPERATOR CLASS

Name

ALTER OPERATOR CLASS -- change the definition of an operator class

Synopsis

ALTER OPERATOR CLASS name USING index_method RENAME TO newname
ALTER OPERATOR CLASS name USING index_method OWNER TO newowner

Description

ALTER OPERATOR CLASS changes the definition of an operator class.

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.

newname

The new name of the operator class.

newowner

The new owner of the operator class. You must be a superuser to change the owner of an operator class.

Compatibility

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.