pg_opfamily
The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement the semantics specified for a particular index access method. Furthermore, the operators in a family are all “compatible”, in a way that is specified by the access method. The operator family concept allows cross-data-type operators to be used with indexes and to be reasoned about using knowledge of access method semantics. Operator families are described at length in Section 36.16.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, opfmethod, opfname, opfnamespace, opfowner
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement the semantics specified for a particular index access method. Furthermore, the operators in a family are all “compatible”, in a way that is specified by the access method. The operator family concept allows cross-data-type operators to be used with indexes and to be reasoned about using knowledge of access method semantics. Operator families are described at length in Section 36.16.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| opfmethod | oid | Not null | Index access method operator family is for |
| opfname | name | Not null | Name of this operator family |
| opfnamespace | oid | Not null | Namespace of this operator family |
| opfowner | oid | Not null | Owner of the operator family |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:2efbce5cea854bdbba7dc11dd243eaef15e67bc595f02b40d38995da18200c96
Text language: en · catalog-bilingual-repair:2efbce5cea854bdbba7dc11dd243eaef15e67bc595f02b40d38995da18200c96