pg_amop

A system table which stores information about operators associated with index access method operator classes

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
- column amoppurpose added (commit 725d52d0)
- column amopsortfamily added (commit 725d52d0)
PostgreSQL 8.4
- column amopreqcheck removed (commit 9b5c8d45)
PostgreSQL 8.3
- column amoplefttype added (commit a78fcfb5)
- column amoprightype added (commit a78fcfb5)
- column amopmethod added (commit a78fcfb5)
- column amopsubtype removed (commit a78fcfb5)
PostgreSQL 8.0
- column amopsubtype added (commit fa5c8a05)

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

Version charts

Useful overviews

Useful links

Contents

pg_amop

Definition by PostgreSQL version

pg_amop (PostgreSQL 16)

pg_amop (PostgreSQL 15)

pg_amop (PostgreSQL 14)

pg_amop (PostgreSQL 13)

pg_amop (PostgreSQL 12)

pg_amop (PostgreSQL 11)

pg_amop (PostgreSQL 10)

pg_amop (PostgreSQL 9.6)

pg_amop (PostgreSQL 9.5)

pg_amop (PostgreSQL 9.4)

pg_amop (PostgreSQL 9.3)

pg_amop (PostgreSQL 9.2)

pg_amop (PostgreSQL 9.1)

pg_amop (PostgreSQL 9.0)

pg_amop (PostgreSQL 8.4)

pg_amop (PostgreSQL 8.3)

pg_amop (PostgreSQL 8.2)

Change history

Examples

References

Categories

See also