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.

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

Columns 4

ColumnTypeDescription / reference
oidoidRow identifier
amnamenameName of the access method
amhandlerregprocOID of a handler function that is responsible for supplying information about the access method
pg_proc.oid
amtypechart = table (including materialized views), i = index.
Column history across versions
Column9.09.19.29.39.49.59.61011121314151617181920
oid···
amname
amhandler······
amtype······
amstrategies············
amsupport············
amcanorder············
amcanbackward············
amcanunique············
amcanmulticol············
amoptionalkey············
amindexnulls·················
amsearchnulls············
amstorage············
amclusterable············
amkeytype············
aminsert············
ambeginscan············
amgettuple············
amgetbitmap············
amrescan············
amendscan············
ammarkpos············
amrestrpos············
ambuild············
ambulkdelete············
amvacuumcleanup············
amcostestimate············
amoptions············
amcanorderbyop·············
ampredlocks·············
ambuildempty·············
amsearcharray··············
amcanreturn··············
Version history 13
  1. PG 17 → 18changed
  2. PG 16 → 17changed
  3. PG 14 → 15changed
  4. PG 13 → 14changed
  5. PG 11 → 12changed
  6. PG 10 → 11changed
  7. PG 9.6 → 10changed
  8. PG 9.5 → 9.6changed
  9. PG 9.4 → 9.5changed
  10. PG 9.3 → 9.4changed
  11. PG 9.2 → 9.3changed
  12. PG 9.1 → 9.2changed
  13. PG 9.0 → 9.1changed

Definition snapshot: english-manuals:758a0e85632b815ae53bc1cb74b… · English manual source