pg_am#

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

Table 1. pg_catalog.pg_am

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