blob: 69523c352b7ff3b5101ecb7228560da220f6d6c4 [file] [log] [blame]
---
title: 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.
<a id="topic1__fx143898"></a>
| column | type | references | description |
|-----------------|---------|-----------------|--------------------------------------------|
| `amopclaid` | oid | pg\_opclass.oid | The index operator class this entry is for |
| `amprocsubtype` | oid | pg\_type.oid | Subtype, if cross-type routine, else zero |
| `amprocnum` | int2 |   | Support procedure number |
| `amproc` | regproc | pg\_proc.oid | OID of the procedure |
: <span class="tablecap">Table 1. pg\_catalog.pg\_amproc</span>