{"Entry":{"collection":"catalog","key":"pg_available_extension_versions","name":"pg_available_extension_versions","aliases":[],"metadata":{"changed_in":["13","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":["trusted"],"attributes":[],"description_changed":false,"descriptions":[{"from":"True if only superusers are allowed to install this extension","name":"superuser","to":"True if only superusers are allowed to install this extension (but see trusted)"}],"from":"12","listing":[],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":["location"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":10,"content_hash":"7ec93772456bb29cf5e172bb402994bf16939314183b6d195f2daf4ee2473dd0","first_version":"9.1","imported_at":"2026-09-30T00:40:55.386465+08:00","kind":"view","last_version":"20","name":"pg_available_extension_versions","position":10,"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:f8ae5d7543e0cbd68570ba6c1932f91f9a499bc021beb4040f9166ea13f2edb8","summary":"The pg_available_extension_versions view lists the specific extension versions that are available for installation.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_available_extension_versions","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_available_extension_versions","SourceRevision":"english-manuals:f8ae5d7543e0cbd68570ba6c1932f91f9a499bc021beb4040f9166ea13f2edb8","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":"Version name","description_zh":"","documented":true,"documented_name":"version","hidden":false,"name":"version","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"True if this version of this extension is currently installed","description_zh":"","documented":true,"documented_name":"installed","hidden":false,"name":"installed","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":4,"description":"True if only superusers are allowed to install this extension (but see trusted)","description_zh":"","documented":true,"documented_name":"superuser","hidden":false,"name":"superuser","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":5,"description":"True if the extension can be installed by non-superusers with appropriate privileges","description_zh":"","documented":true,"documented_name":"trusted","hidden":false,"name":"trusted","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":6,"description":"True if extension can be relocated to another schema","description_zh":"","documented":true,"documented_name":"relocatable","hidden":false,"name":"relocatable","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"Name of the schema that the extension must be installed into, or NULL if partially or fully relocatable","description_zh":"","documented":true,"documented_name":"schema","hidden":false,"name":"schema","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":8,"description":"Names of prerequisite extensions, or NULL if none","description_zh":"","documented":true,"documented_name":"requires","hidden":false,"name":"requires","not_null":false,"references":"","type":"name[]","type_modifier":-1,"type_oid":1003},{"array_dimensions":0,"attnum":9,"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_extension_versions view lists the specific extension versions 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.8.4","file":"view-pg-available-extension-versions.html","lang":"en","sha256":"8e9566d8385352f2c085eb13bb67ec563a5ddd9b4b754ec0b5e1ead22dc7aa11","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","version","installed","superuser","trusted","relocatable","schema","requires","comment"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.8.4","file":"view-pg-available-extension-versions.html","lang":"en","sha256":"8e9566d8385352f2c085eb13bb67ec563a5ddd9b4b754ec0b5e1ead22dc7aa11","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","version","installed","superuser","trusted","relocatable","schema","requires","comment"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_available_extension_versions","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_available_extension_versions","Summary":"pg_available_extension_versions视图列出了可供安装的特定扩展版本。另请参阅pg_extension目录，其中显示当前已安装的扩展。","BodyHTML":"\u003cp\u003epg_available_extension_versions视图列出了可供安装的特定扩展版本。另请参阅pg_extension目录，其中显示当前已安装的扩展。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"45866aad32d9cc7fb157ac57f60c42a29d92d67335f12378754aa25206dc68f8","Payload":{"columns":[{"description_zh":"扩展名","name":"name","type":"name","zh_from":"doc"},{"description_zh":"版本名","name":"version","type":"text","zh_from":"doc"},{"description_zh":"如果此版本的扩展当前已安装则为真","name":"installed","type":"boolean","zh_from":"doc"},{"description_zh":"如果只有超级用户可以安装此扩展，则为真（但另请参见 trusted）","name":"superuser","type":"boolean","zh_from":"doc"},{"description_zh":"如果扩展可以由具有适当权限的非超级用户安装，则为真","name":"trusted","type":"boolean","zh_from":"doc"},{"description_zh":"如果扩展能被重定位到另一个模式则为真","name":"relocatable","type":"boolean","zh_from":"doc"},{"description_zh":"此扩展必须被安装到的模式名，如果此扩展是部分或者全部可以重定位的，此列为NULL","name":"schema","type":"name","zh_from":"doc"},{"description_zh":"所依赖扩展的名称，如果没有则为NULL","name":"requires","type":"name[]","zh_from":"doc"},{"description_zh":"来自于扩展的控制文件的注释字符串","name":"comment","type":"text","zh_from":"doc"}],"description_zh":"pg_available_extension_versions视图列出了可供安装的特定扩展版本。另请参阅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}