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 | - | Row identifier (hidden attribute; must be explicitly selected) |
| opfmethod | oid | PG_AM.oid | Index access method the operator family is for |
| opfname | name | - | 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.
Last Article: PG_OPERATOR
Next Article: PG_PARTITION
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.