PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_amop

Read PG 18 manual ↗

The catalog pg_amop stores information about operators associated with access method operator families.

Kind: System catalogs
Columns in this snapshot: 9
Definition source: English manual

Columns 9

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`amopfamily`	`oid`	The operator family this entry is for pg_opfamily.oid
`amoplefttype`	`oid`	Left-hand input data type of operator pg_type.oid
`amoprighttype`	`oid`	Right-hand input data type of operator pg_type.oid
`amopstrategy`	`int2`	Operator strategy number
`amoppurpose`	`char`	Operator purpose, either s for search or o for ordering
`amopopr`	`oid`	OID of the operator pg_operator.oid
`amopmethod`	`oid`	Index access method operator family is for pg_am.oid
`amopsortfamily`	`oid`	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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amopfamily`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amoplefttype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amoprighttype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amopstrategy`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amoppurpose`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amopopr`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amopmethod`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`amopsortfamily`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 4

Definition snapshot: english-manuals:821a5accc36ae240326edd4d04e… · English manual source