The pg_amop catalog provides information about operators associated with access method operator families.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
amopfamily |
oid (references pg_opfamily.oid) |
The operator family to which this entry belongs. |
amoplefttype |
oid (references pg_type.oid) |
A left-hand input data type of the operator. |
amoprighttype |
oid (references pg_type.oid) |
The right-hand input data type of the operator. |
amopstrategy |
int2 |
An operator strategy number. |
amoppurpose |
char |
The purpose of the operator. The possible values are:
|
amopopr |
oid (references pg_operator.oid) |
The OID of the operator. |
amopmethod |
oid (references pg_am.oid) |
The index access method the operator family is defined for. |
amopsortfamily |
oid (references pg_opfamily.oid) |
The B-tree operator family according to which this entry sorts. Applies to an ordering operator.0 – For a search operator. |