The pg_amproc table stores information about support procedures associated with index access method operator classes. There is one row for each support procedure belonging to an operator class.

    columntypereferencesdescription
    oidoid Row identifier (hidden attribute; must be explicitly selected)
    amprocfamilyoidpg_opfamily.oidThe operator family this entry is for
    amproclefttypeoidpg_type.oidLeft-hand input data type of associated operator
    amprocrighttypeoidpg_type.oidRight-hand input data type of associated operator
    amprocnumint2 Support procedure number
    amprocregprocpg_proc.oidOID of the procedure

    Parent topic: System Catalogs Definitions