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 |