pg_amop
pg_amop
is a system catalogue table which stores information about operators associated with index access method operator classes.
pg_amop
has always been present in PostgreSQL.
Definition by PostgreSQL version
pg_amop (PostgreSQL 16)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- oid | oid | | not null | amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_oid_index" PRIMARY KEY, btree (oid) "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 15)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- oid | oid | | not null | amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_oid_index" PRIMARY KEY, btree (oid) "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 14)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- oid | oid | | not null | amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_oid_index" PRIMARY KEY, btree (oid) "pg_amop_fam_strat_index" UNIQUE CONSTRAINT, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_opr_fam_index" UNIQUE CONSTRAINT, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 13)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- oid | oid | | not null | amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 12)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- oid | oid | | not null | amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 11)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 10)
Table "pg_catalog.pg_amop" Column | Type | Collation | Nullable | Default ----------------+----------+-----------+----------+--------- amopfamily | oid | | not null | amoplefttype | oid | | not null | amoprighttype | oid | | not null | amopstrategy | smallint | | not null | amoppurpose | "char" | | not null | amopopr | oid | | not null | amopmethod | oid | | not null | amopsortfamily | oid | | not null | Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.6)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.5)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.4)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.3)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.2)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.1)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ----------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amoppurpose | "char" | not null amopopr | oid | not null amopmethod | oid | not null amopsortfamily | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amoppurpose, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 9.0)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ---------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amopopr | oid | not null amopmethod | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 8.4)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ---------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amopopr | oid | not null amopmethod | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 8.3)
Table "pg_catalog.pg_amop" Column | Type | Modifiers ---------------+----------+----------- amopfamily | oid | not null amoplefttype | oid | not null amoprighttype | oid | not null amopstrategy | smallint | not null amopreqcheck | boolean | not null amopopr | oid | not null amopmethod | oid | not null Indexes: "pg_amop_fam_strat_index" UNIQUE, btree (amopfamily, amoplefttype, amoprighttype, amopstrategy) "pg_amop_oid_index" UNIQUE, btree (oid) "pg_amop_opr_fam_index" UNIQUE, btree (amopopr, amopfamily)
Documentation: pg_amop
pg_amop (PostgreSQL 8.2)
Table "pg_catalog.pg_amop" Column | Type | Modifiers --------------+----------+----------- amopclaid | oid | not null amopsubtype | oid | not null amopstrategy | smallint | not null amopreqcheck | boolean | not null amopopr | oid | not null Indexes: "pg_amop_opc_strat_index" UNIQUE, btree (amopclaid, amopsubtype, amopstrategy) "pg_amop_opr_opc_index" UNIQUE, btree (amopopr, amopclaid)
Documentation: pg_amop
Change history
- PostgreSQL 9.1
- PostgreSQL 8.4
- column
amopreqcheck
removed (commit 9b5c8d45)
- column
- PostgreSQL 8.3
- PostgreSQL 8.0
- column
amopsubtype
added (commit fa5c8a05)
- column
Note: list does not include any changes prior to PostgreSQL 7.3
Examples
Sample record from pg_amop
:
postgres=# SELECT * FROM pg_amop LIMIT 1\x\g\x Expanded display is on. -[ RECORD 1 ]--+------ oid | 10118 amopfamily | 1976 amoplefttype | 21 amoprighttype | 21 amopstrategy | 1 amoppurpose | s amopopr | 95 amopmethod | 403 amopsortfamily | 0
References
- PostgreSQL documentation: pg_amop