Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

42.4. pg_amop

The catalog pg_amop stores information about operators associated with index access method operator classes. There is one row for each operator that is a member of an operator class.

Table 42-4. pg_amop Columns

Name Type References Description
amopclaid oid pg_opclass.oid The index operator class this entry is for
amopsubtype oid pg_type.oid Subtype to distinguish multiple entries for one strategy; zero for default
amopstrategy int2   Operator strategy number
amopreqcheck bool   Index hit must be rechecked
amopopr oid pg_operator.oid OID of the operator