Skip to content

pg_am

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

columntypereferencesdescription
oidoidRow identifier (hidden attribute; must be explicitly selected)
amnamenameName of the access method
amhandlerregprocOID of a handler function responsible for supplying information about the access method
amtypechart for table (including materialized views), i for index

Parent topic: System Catalogs Definitions