pg_amproc

A system catalogue table storing information about support procedures associated with index access method operator classes

pg_amproc is a system catalogue table storing information about support procedures associated with index access method operator classes.

Definition by PostgreSQL version

pg_amproc (PostgreSQL 13)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null |
 amprocfamily    | oid      |           | not null |
 amproclefttype  | oid      |           | not null |
 amprocrighttype | oid      |           | not null |
 amprocnum       | smallint |           | not null |
 amproc          | regproc  |           | not null |
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 12)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
 oid             | oid      |           | not null |
 amprocfamily    | oid      |           | not null |
 amproclefttype  | oid      |           | not null |
 amprocrighttype | oid      |           | not null |
 amprocnum       | smallint |           | not null |
 amproc          | regproc  |           | not null |
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 11)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
 amprocfamily    | oid      |           | not null |
 amproclefttype  | oid      |           | not null |
 amprocrighttype | oid      |           | not null |
 amprocnum       | smallint |           | not null |
 amproc          | regproc  |           | not null |
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 10)

                Table "pg_catalog.pg_amproc"
     Column      |   Type   | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
 amprocfamily    | oid      |           | not null |
 amproclefttype  | oid      |           | not null |
 amprocrighttype | oid      |           | not null |
 amprocnum       | smallint |           | not null |
 amproc          | regproc  |           | not null |
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.6)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.5)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.4)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.3)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.2)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.1)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 9.0)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 8.4)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 8.3)

      Table "pg_catalog.pg_amproc"
     Column      |   Type   | Modifiers
-----------------+----------+-----------
 amprocfamily    | oid      | not null
 amproclefttype  | oid      | not null
 amprocrighttype | oid      | not null
 amprocnum       | smallint | not null
 amproc          | regproc  | not null
Indexes:
    "pg_amproc_fam_proc_index" UNIQUE, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)
    "pg_amproc_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_amproc

pg_amproc (PostgreSQL 8.2)

     Table "pg_catalog.pg_amproc"
    Column     |   Type   | Modifiers
---------------+----------+-----------
 amopclaid     | oid      | not null
 amprocsubtype | oid      | not null
 amprocnum     | smallint | not null
 amproc        | regproc  | not null
Indexes:
    "pg_amproc_opc_proc_index" UNIQUE, btree (amopclaid, amprocsubtype, amprocnum)
    

Documentation: pg_amproc

Change history

  • PostgreSQL 8.3
    • column amprocsubtype removed
    • column amproclefttype added
    • column amprocrighttype added
  • PostgreSQL 8.0
    • column amprocsubtype added

Note: list does not include any changes prior to PostgreSQL 7.3

Examples

postgres=# SELECT * FROM pg_amproc WHERE amproc='btboolcmp'::REGPROC;
  oid  | amprocfamily | amproclefttype | amprocrighttype | amprocnum |  amproc  
-------+--------------+----------------+-----------------+-----------+-----------
 10835 |          424 |             16 |              16 |         1 | btboolcmp
(1 row)

Categories

System catalogue

See also

pg_am, pg_amop