{"Entry":{"collection":"catalog","key":"pg_am","name":"pg_am","aliases":[],"metadata":{"changed_in":["8.1","8.2","8.3","8.4","9.1","9.2","9.6","12"],"changes":[{"added":["amoptionalkey","amgetmulti"],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.0","listing":[],"order":true,"removed":["amowner"],"status":"changed","to":"8.1","types":[],"unlisted":[]},{"added":["amstorage","amclusterable","amoptions"],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.1","listing":[],"order":false,"removed":["amconcurrent"],"status":"changed","to":"8.2","types":[],"unlisted":[]},{"added":["amcanorder","amsearchnulls"],"attributes":[],"description_changed":true,"descriptions":[{"from":"Number of operator strategies for this access method","name":"amstrategies","to":"Number of operator strategies for this access method, or zero if access method does not have a fixed set of operator strategies"}],"from":"8.2","listing":[],"order":false,"removed":["amorderstrategy"],"status":"changed","to":"8.3","types":[],"unlisted":[]},{"added":["amcanbackward","amkeytype","amgetbitmap"],"attributes":[],"description_changed":false,"descriptions":[{"from":"\"Next valid tuple\" function","name":"amgettuple","to":"\"Next valid tuple\" function, or zero if none"}],"from":"8.3","listing":[],"order":false,"removed":["amgetmulti"],"status":"changed","to":"8.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Does the access method support IS NULL searches?","name":"amsearchnulls","to":"Does the access method support IS NULL/NOT NULL searches?"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":["amcanorderbyop","ampredlocks","ambuildempty"],"attributes":[],"description_changed":true,"descriptions":[{"from":"\"Start new scan\" function","name":"ambeginscan","to":"\"Prepare for index scan\" function"},{"from":"Does the access method support ordered scans?","name":"amcanorder","to":"Does the access method support ordered scans sorted by the indexed column's value?"},{"from":"\"End this scan\" function","name":"amendscan","to":"\"Clean up after index scan\" function"},{"from":"\"Restart this scan\" function","name":"amrescan","to":"\"(Re)start index scan\" function"}],"from":"9.0","listing":[],"order":false,"removed":["amindexnulls"],"status":"changed","to":"9.1","types":[],"unlisted":[]},{"added":["amsearcharray","amcanreturn"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"changed","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.3","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Function to check whether index supports index-only scans, or zero if none","name":"amcanreturn","to":"Function to check whether an index column supports index-only scans. Can be zero if index-only scans are never supported."}],"from":"9.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.5","types":[],"unlisted":[]},{"added":["amhandler","amtype"],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":["amstrategies","amsupport","amcanorder","amcanorderbyop","amcanbackward","amcanunique","amcanmulticol","amoptionalkey","amsearcharray","amsearchnulls","amstorage","amclusterable","ampredlocks","amkeytype","aminsert","ambeginscan","amgettuple","amgetbitmap","amrescan","amendscan","ammarkpos","amrestrpos","ambuild","ambuildempty","ambulkdelete","amvacuumcleanup","amcanreturn","amcostestimate","amoptions"],"status":"changed","to":"9.6","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[{"from":"Currently always i to indicate an index access method; other values may be allowed in future","name":"amtype","to":"t = table (including materialized views), i = index."}],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]}],"column_count":4,"content_hash":"62579a255f42cbc799e6cc29f3ccab95823107fd59b94486a3b066efef028ae6","first_version":"7.4","imported_at":"2026-09-30T00:40:55.304621+08:00","kind":"catalog","last_version":"20","name":"pg_am","position":2,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:e69c93df7125f894838518ef72c58293983aab75ed46cb4340300f898beb7041","summary":"The catalog pg_am stores information about relation access methods.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_am","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_am","SourceRevision":"english-manuals:e69c93df7125f894838518ef72c58293983aab75ed46cb4340300f898beb7041","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Name of the access method","description_zh":"","documented":true,"documented_name":"amname","hidden":false,"name":"amname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"OID of a handler function that is responsible for supplying information about the access method","description_zh":"","documented":true,"documented_name":"amhandler","hidden":false,"name":"amhandler","not_null":true,"references":"pg_proc.oid","type":"regproc","type_modifier":-1,"type_oid":24},{"array_dimensions":0,"attnum":4,"description":"t = table (including materialized views), i = index.","description_zh":"","documented":true,"documented_name":"amtype","hidden":false,"name":"amtype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18}],"description":"The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only tables and indexes have access methods. The requirements for table and index access methods are discussed in detail in Chapter 62 and Chapter 63 respectively.","description_zh":"","doc":{"anchor":"id-1.10.4.5.4","file":"catalog-pg-am.html","lang":"en","sha256":"579364179365a51945e2edb6481df5d198916c2c725e506f166824dedf08994c","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","amname","amhandler","amtype"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.5.4","file":"catalog-pg-am.html","lang":"en","sha256":"579364179365a51945e2edb6481df5d198916c2c725e506f166824dedf08994c","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","amname","amhandler","amtype"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_am","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_am","Summary":"目录pg_am存储关于关系访问方法的信息。系统支持的每种访问方法在这个目录中都有一行。目前只有表和索引拥有访问方法。表和索引访问方法的需求分别在第 62 章和第 63 章中详细讨论。","BodyHTML":"\u003cp\u003e目录pg_am存储关于关系访问方法的信息。系统支持的每种访问方法在这个目录中都有一行。目前只有表和索引拥有访问方法。表和索引访问方法的需求分别在第 62 章和第 63 章中详细讨论。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"02ceb05e09a4ff39e19918c45ffd2c07c12d24d538bdfc47da6dccc2a5c62a37","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"访问方法的名字","name":"amname","type":"name","zh_from":"doc"},{"description_zh":"负责提供有关该访问方法信息的处理器函数的 OID","name":"amhandler","type":"regproc","zh_from":"doc"},{"description_zh":"t = 表（包括物化视图），i = 索引。","name":"amtype","type":"\"char\"","zh_from":"doc"}],"description_zh":"目录pg_am存储关于关系访问方法的信息。系统支持的每种访问方法在这个目录中都有一行。目前只有表和索引拥有访问方法。表和索引访问方法的需求分别在第 62 章和第 63 章中详细讨论。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}