pg_am
The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only tables and indexes have access methods. The requirements for table and index access methods are discussed in detail in Chapter 62 and Chapter 63 respectively.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, amname, amhandler, amtype
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only tables and indexes have access methods. The requirements for table and index access methods are discussed in detail in Chapter 62 and Chapter 63 respectively.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| amname | name | Not null | Name of the access method |
| amhandler | regproc | Not null | OID of a handler function that is responsible for supplying information about the access method |
| amtype | char | Not null | t = table (including materialized views), i = index. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:39b63c76caa7fa8aad67ba3d3edae987fbd260c0755974cc602f7547dcc064e5
Text language: en · catalog-bilingual-repair:39b63c76caa7fa8aad67ba3d3edae987fbd260c0755974cc602f7547dcc064e5