Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_OPFAMILY

PG_OPFAMILY

Updated at: Dec 30, 2020 GMT+08:00

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.

Table 1 PG_OPFAMILY columns

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel