Skip to main content
Version: Next

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.

columntypereferencesdescription
oidoid Row identifier (hidden attribute; must be explicitly selected)
amnamename Name 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