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.