System Catalogs / System catalogs
pg_amop
Read the PG 18 manualThe catalog pg_amop stores information about operators associated with access method operator families.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 9
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 9
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
amopfamily | oidNOT NULL | The operator family this entry is for pg_opfamily.oid |
amoplefttype | oidNOT NULL | Left-hand input data type of operator pg_type.oid |
amoprighttype | oidNOT NULL | Right-hand input data type of operator pg_type.oid |
amopstrategy | int2NOT NULL | Operator strategy number |
amoppurpose | charNOT NULL | Operator purpose, either s for search or o for ordering |
amopopr | oidNOT NULL | OID of the operator pg_operator.oid |
amopmethod | oidNOT NULL | Index access method operator family is for pg_am.oid |
amopsortfamily | oidNOT NULL | The B-tree operator family this entry sorts according to, if an ordering operator; zero if a search operator pg_opfamily.oid |
Column history across versions
Version history 6
Definition snapshot: english-manuals:118aa05875ef279d076cc032649… · English manual source