↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / System Catalogs

pg_amproc

The catalog pg_amproc stores information about support functions associated with access method operator families. There is one row for each support function belonging to an operator family.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

kind
catalog
lang
en
measured attributes
true
metadata release
18.6
runtime columns
oid, amprocfamily, amproclefttype, amprocrighttype, amprocnum, amproc
runtime verified
false
source
english-manual

Definition PG 18

The catalog pg_amproc stores information about support functions associated with access method operator families. There is one row for each support function belonging to an operator family.

Catalog columns

ColumnTypeNullabilityDescription
oidoidNot nullRow identifier
amprocfamilyoidNot nullThe operator family this entry is for
amproclefttypeoidNot nullLeft-hand input data type of associated operator
amprocrighttypeoidNot nullRight-hand input data type of associated operator
amprocnumint2Not nullSupport function number
amprocregprocNot nullOID of the function

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:e6857bbb0ac309d5112570c87604aa191540a27de8e48638784998385e157129

Text language: en · catalog-bilingual-repair:e6857bbb0ac309d5112570c87604aa191540a27de8e48638784998385e157129