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 | tfor table (including materialized views),ifor index |