pg_amproc
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 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
- column
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