The pg_opclass catalog provides information about operator classes.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
opcmethod |
oid (references pg_am.oid) |
Specifies the index access method to which the operator class belongs. |
opcname |
name |
The name of the operator class. |
opcnamespace |
oid (references pg_namespace.oid) |
The OID of the namespace in which the operator class is defined. |
opcowner |
oid (references pg_authid.oid) |
The owner of the operator class. |
opcfamily |
oid (references pg_opfamily.oid) |
The operator family containing the operator class. |
opcintype |
oid (references pg_type.oid) |
The data type that the operator class indexes. |
opcdefault |
bool |
Specifies whether the operator class is the default for opcintype (TRUE) or not (FALSE). |
opckeytype |
oid (references pg_type.oid) |
The data type stored in the index. The value is 0 if the data type is the same as opcintype. |