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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.