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 |