Postgresql 中文操作指南
54.3. pg_available_extension_versions #
pg_available_extension_versions 视图列出了可用于安装的特定扩展版本。另请参见 pg_extension 目录,其中显示了当前安装的扩展。
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.
Table 54.3. pg_available_extension_versions Columns
Table 54.3. pg_available_extension_versions Columns
Column Type Description |
name name Extension name |
version text Version name |
installed bool True if this version of this extension is currently installed |
superuser bool True if only superusers are allowed to install this extension (but see trusted) |
trusted bool True if the extension can be installed by non-superusers with appropriate privileges |
relocatable bool True if extension can be relocated to another schema |
schema name Name of the schema that the extension must be installed into, or NULL if partially or fully relocatable |
requires name[] Names of prerequisite extensions, or NULL if none |
comment text Comment string from the extension’s control file |
pg_available_extension_versions:视图为只读。
The pg_available_extension_versions view is read-only.