System Catalogs / System catalogs
pg_opclass
Read the PG 18 manualThe catalog pg_opclass defines index access method operator classes.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 9
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 9
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
opcmethod | oidNOT NULL | Index access method operator class is for pg_am.oid |
opcname | nameNOT NULL | Name of this operator class |
opcnamespace | oidNOT NULL | Namespace of this operator class pg_namespace.oid |
opcowner | oidNOT NULL | Owner of the operator class pg_authid.oid |
opcfamily | oidNOT NULL | Operator family containing the operator class pg_opfamily.oid |
opcintype | oidNOT NULL | Data type that the operator class indexes pg_type.oid |
opcdefault | boolNOT NULL | True if this operator class is the default for opcintype |
opckeytype | oidNOT NULL | Type of data stored in index, or zero if same as opcintype pg_type.oid |
Column history across versions
Version history 12
Definition snapshot: english-manuals:5ff649e77c28125ad7fd33db6d2… · English manual source