pg_amop

pg_amop

The pg_amop table 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 1. pg_catalog.pg_amop
column 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 boolean   Index hit must be rechecked
amopopr oid pg_operator.oid OID of the operator