{"Entry":{"collection":"catalog","key":"pg_extension","name":"pg_extension","aliases":[],"metadata":{"changed_in":["9.5","12"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":[],"attributes":[{"attribute":"not_null","from":false,"name":"extversion","to":true}],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","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":"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":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]}],"column_count":8,"content_hash":"0ed0baa255a1a282060b26f52871ec66b223be8bde2634ba94a41bb56fcc935e","first_version":"9.1","imported_at":"2026-09-30T00:40:55.527479+08:00","kind":"catalog","last_version":"20","name":"pg_extension","position":28,"present_in":["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:694e77f2d5ca730e46798aabbf07d287d77d919e268d303d273dd618e988c754","summary":"The catalog pg_extension stores information about the installed extensions.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_extension","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_extension","SourceRevision":"english-manuals:694e77f2d5ca730e46798aabbf07d287d77d919e268d303d273dd618e988c754","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 extension","description_zh":"","documented":true,"documented_name":"extname","hidden":false,"name":"extname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Owner of the extension","description_zh":"","documented":true,"documented_name":"extowner","hidden":false,"name":"extowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":4,"description":"Schema containing the extension's exported objects","description_zh":"","documented":true,"documented_name":"extnamespace","hidden":false,"name":"extnamespace","not_null":true,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"True if extension can be relocated to another schema","description_zh":"","documented":true,"documented_name":"extrelocatable","hidden":false,"name":"extrelocatable","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":6,"description":"Version name for the extension","description_zh":"","documented":true,"documented_name":"extversion","hidden":false,"name":"extversion","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":1,"attnum":7,"description":"Array of regclass OIDs for the extension's configuration table(s), or NULL if none","description_zh":"","documented":true,"documented_name":"extconfig","hidden":false,"name":"extconfig","not_null":false,"references":"pg_class.oid","type":"oid[]","type_modifier":-1,"type_oid":1028},{"array_dimensions":1,"attnum":8,"description":"Array of WHERE-clause filter conditions for the extension's configuration table(s), or NULL if none","description_zh":"","documented":true,"documented_name":"extcondition","hidden":false,"name":"extcondition","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009}],"description":"The catalog pg_extension stores information about the installed extensions. See Section 36.17 for details about extensions.","description_zh":"","doc":{"anchor":"id-1.10.4.24.4","file":"catalog-pg-extension.html","lang":"en","sha256":"844764e683a62f5c4040c4618388dfbc5477e2fe7d647c8f77e5fe98e9f136a6","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","extname","extowner","extnamespace","extrelocatable","extversion","extconfig","extcondition"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.24.4","file":"catalog-pg-extension.html","lang":"en","sha256":"844764e683a62f5c4040c4618388dfbc5477e2fe7d647c8f77e5fe98e9f136a6","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","extname","extowner","extnamespace","extrelocatable","extversion","extconfig","extcondition"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_extension","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_extension","Summary":"目录pg_extension存储有关已安装扩展的信息。有关扩展的细节请参见第 36.17 节。","BodyHTML":"\u003cp\u003e目录pg_extension存储有关已安装扩展的信息。有关扩展的细节请参见第 36.17 节。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"45ecd1a36d217f1b919772c116977eba8b6a953f5240e989162154a3c9301f11","Payload":{"columns":[{"description_zh":"行标识符","name":"oid","type":"oid","zh_from":"doc"},{"description_zh":"扩展的名字","name":"extname","type":"name","zh_from":"doc"},{"description_zh":"扩展的拥有者","name":"extowner","type":"oid","zh_from":"doc"},{"description_zh":"包含此扩展的导出对象的模式","name":"extnamespace","type":"oid","zh_from":"doc"},{"description_zh":"如果扩展可被重定位到另一个模式则为真","name":"extrelocatable","type":"boolean","zh_from":"doc"},{"description_zh":"扩展的版本名字","name":"extversion","type":"text","zh_from":"doc"},{"description_zh":"扩展配置表的 regclass OID 数组；如果没有配置表，则为 NULL","name":"extconfig","type":"oid[]","zh_from":"doc"},{"description_zh":"扩展的配置表的WHERE子句过滤条件的数组，如果没有则为NULL","name":"extcondition","type":"text[]","zh_from":"doc"}],"description_zh":"目录pg_extension存储有关已安装扩展的信息。有关扩展的细节请参见第 36.17 节。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}