pg_amproc

A system 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.

pg_amproc has always been present in PostgreSQL.

Definition by PostgreSQL version

pg_amproc (PostgreSQL 16)

                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_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

Documentation: pg_amproc

pg_amproc (PostgreSQL 15)

                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_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

Documentation: pg_amproc

pg_amproc (PostgreSQL 14)

                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_oid_index" PRIMARY KEY, btree (oid)
    "pg_amproc_fam_proc_index" UNIQUE CONSTRAINT, btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)

Documentation: pg_amproc

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)

References

PostgreSQL documentation: pg_amproc

Version charts

Useful overviews

Useful links

Contents

pg_amproc

Definition by PostgreSQL version

pg_amproc (PostgreSQL 16)

pg_amproc (PostgreSQL 15)

pg_amproc (PostgreSQL 14)

pg_amproc (PostgreSQL 13)

pg_amproc (PostgreSQL 12)

pg_amproc (PostgreSQL 11)

pg_amproc (PostgreSQL 10)

pg_amproc (PostgreSQL 9.6)

pg_amproc (PostgreSQL 9.5)

pg_amproc (PostgreSQL 9.4)

pg_amproc (PostgreSQL 9.3)

pg_amproc (PostgreSQL 9.2)

pg_amproc (PostgreSQL 9.1)

pg_amproc (PostgreSQL 9.0)

pg_amproc (PostgreSQL 8.4)

pg_amproc (PostgreSQL 8.3)

pg_amproc (PostgreSQL 8.2)

Change history

Examples

References

Categories

See also