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

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_opclass

Read PG 18 manual ↗

The catalog pg_opclass defines index access method operator classes.

Kind: System catalogs
Columns in this snapshot: 9
Definition source: English manual

Columns 9

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`opcmethod`	`oid`	Index access method operator class is for pg_am.oid
`opcname`	`name`	Name of this operator class
`opcnamespace`	`oid`	Namespace of this operator class pg_namespace.oid
`opcowner`	`oid`	Owner of the operator class pg_authid.oid
`opcfamily`	`oid`	Operator family containing the operator class pg_opfamily.oid
`opcintype`	`oid`	Data type that the operator class indexes pg_type.oid
`opcdefault`	`bool`	True if this operator class is the default for opcintype
`opckeytype`	`oid`	Type of data stored in index, or zero if same as opcintype pg_type.oid

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcmethod`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcnamespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcfamily`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcintype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opcdefault`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`opckeytype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 8

Definition snapshot: english-manuals:04fac048e0aa36da2b46a7ee7ab… · English manual source