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

# pg_am

The `pg_am` table in the `pg_catalog` schema stores information about index access methods. There is one row for each index access method supported by the system.

|column|type|references|description|
|------|----|----------|-----------|
|`oid`|oid| |Row identifier (hidden attribute; must be explicitly selected)|
|`amname`|name| |Name of the access method|
|`amhandler`|regproc| | OID of a handler function responsible for supplying information about the access method|
|`amtype`|char| |`t` for table (including materialized views), `i` for index|