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

columntypereferencesdescription
amopclaidoidpg_opclass.oidThe index operator class this entry is for
amopsubtypeoidpg_type.oidSubtype to distinguish multiple entries for one strategy; zero for default
amopstrategysmallint Operator strategy number
amopreqcheckboolean Index hit must be rechecked
amopoproidpg_operator.oidOID of the operator