↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System catalogs

The catalog pg_am stores information about relation access methods.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

Kind
System catalogs
Columns in this snapshot
4
Definition source
English manual
Metadata snapshot
18.6

Columns 4

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
amnamenameNOT NULLName of the access method
amhandlerregprocNOT NULLOID of a handler function that is responsible for supplying information about the access method
pg_proc.oid
amtypecharNOT NULLt = table (including materialized views), i = index.
Column history across versions
Version history 18
  1. 17 → 18 reworded
  2. 16 → 17 reworded
  3. 14 → 15 reworded
  4. 13 → 14 reworded
  5. 11 → 12 changed
  6. 10 → 11 reworded
  7. 9.6 → 10 reworded
  8. 9.5 → 9.6 changed
  9. 9.4 → 9.5 reworded
  10. 9.3 → 9.4 reworded
  11. 9.2 → 9.3 reworded
  12. 9.1 → 9.2 changed
  13. 9.0 → 9.1 changed
  14. 8.4 → 9.0 reworded
  15. 8.3 → 8.4 changed
  16. 8.2 → 8.3 changed
  17. 8.1 → 8.2 changed
  18. 8.0 → 8.1 changed

Definition snapshot: english-manuals:e69c93df7125f894838518ef72c… · English manual source