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.
| 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 |
Parent topic: System Catalogs Definitions
