{"Entry":{"collection":"catalog","key":"pg_available_extensions","name":"pg_available_extensions","aliases":[],"metadata":{"changed_in":["19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":["location"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":5,"content_hash":"d34b1677249c00397f0ff59e118a8aad28832c0a0900299f9fa4a0d649877378","first_version":"9.1","imported_at":"2026-09-30T00:40:55.391225+08:00","kind":"view","last_version":"20","name":"pg_available_extensions","position":11,"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":"v","shared":false,"source_rev":"english-manuals:cff06718cbba3e1c602627824f427c169b6d93bd6b01f13f766bc50cb0efa00d","summary":"The pg_available_extensions view lists the extensions that are available for installation.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_available_extensions","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_available_extensions","SourceRevision":"english-manuals:cff06718cbba3e1c602627824f427c169b6d93bd6b01f13f766bc50cb0efa00d","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Extension name","description_zh":"","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":2,"description":"Name of default version, or NULL if none is specified","description_zh":"","documented":true,"documented_name":"default_version","hidden":false,"name":"default_version","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"Currently installed version of the extension, or NULL if not installed","description_zh":"","documented":true,"documented_name":"installed_version","hidden":false,"name":"installed_version","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":4,"description":"Comment string from the extension's control file","description_zh":"","documented":true,"documented_name":"comment","hidden":false,"name":"comment","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"The pg_available_extensions view lists the extensions that are available for installation. See also the pg_extension catalog, which shows the extensions currently installed.","description_zh":"","doc":{"anchor":"id-1.10.5.7.4","file":"view-pg-available-extensions.html","lang":"en","sha256":"994a95c453c45da8106e01301b69981208ac303843fbd5e3ac65f5efccb8ea8d","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","default_version","installed_version","comment"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.7.4","file":"view-pg-available-extensions.html","lang":"en","sha256":"994a95c453c45da8106e01301b69981208ac303843fbd5e3ac65f5efccb8ea8d","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","default_version","installed_version","comment"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_available_extensions","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_available_extensions","Summary":"pg_available_extensions视图列出了可供安装的扩展。另请参阅pg_extension目录，其中显示当前已安装的扩展。","BodyHTML":"\u003cp\u003epg_available_extensions视图列出了可供安装的扩展。另请参阅pg_extension目录，其中显示当前已安装的扩展。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"69181dc66456114cdd33a1a908d9ffc001e166b01d3576682d01a69d22494d7c","Payload":{"columns":[{"description_zh":"扩展名","name":"name","type":"name","zh_from":"doc"},{"description_zh":"默认版本的名称，如果没有指定则为NULL","name":"default_version","type":"text","zh_from":"doc"},{"description_zh":"当前已安装的扩展版本，如果没有安装则为NULL","name":"installed_version","type":"text","zh_from":"doc"},{"description_zh":"来自于扩展的控制文件的注释字符串","name":"comment","type":"text","zh_from":"doc"}],"description_zh":"pg_available_extensions视图列出了可供安装的扩展。另请参阅pg_extension目录，其中显示当前已安装的扩展。","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}