---
title: "pg_amproc"
source: https://cloudberry.apache.org/docs/sys-catalogs/sys-tables/pg-amproc
---

# pg_amproc

The `pg_amproc` table in the `pg_catalog` schema 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`|smallint| |Support procedure number|
|`amproc`|regproc|`pg_proc.oid`|OID of the procedure|