pg_amproc

pg_amproc

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.

Table 1. pg_catalog.pg_amproc
column type references description
oid oid   Row identifier (hidden attribute; must be explicitly selected)
amprocfamily oid pg_opfamily.oid The operator family this entry is for
amproclefttype oid pg_type.oid Left-hand input data type of associated operator
amprocrighttype oid pg_type.oid Right-hand input data type of associated operator
amprocnum int2   Support procedure number
amproc regproc pg_proc.oid OID of the procedure