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

smallint

Support procedure number

amproc

regproc

pg_proc.oid

OID of the procedure