pg_amproc — PostgreSQL system catalog

The PostgreSQL pg_amproc system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_amproc system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • oid oid
    Row identifier
  • amprocfamily oid references pg_opfamily.oid
    The operator family this entry is for
  • amproclefttype oid references pg_type.oid
    Left-hand input data type of associated operator
  • amprocrighttype oid references pg_type.oid
    Right-hand input data type of associated operator
  • amprocnum int2
    Support function number
  • amproc regproc references pg_proc.oid
    OID of the function

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_amproc.