PG_OPFAMILY¶
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.
Name | Type | Reference | Description |
|---|---|---|---|
OID | OID | N/A | Row identifier (hidden attribute; displayed only when explicitly selected) |
opfmethod | OID | PG_AM.oid | Index method used by the operator family |
opfname | Name | N/A | Name of the operator family |
opfnamespace | OID | PG_NAMESPACE.oid | Namespace of the operator family |
opfowner | OID | PG_AUTHID.oid | Owner of the operator family |
The majority of the information defining an operator family is not in PG_OPFAMILY, but in the associated PG_AMOP, PG_AMPROC, and PG_OPCLASS.