pg_available_extension_versions

The pg_available_extension_versions view lists the specific extension versions that are available for installation.

Columns 9

Column	Type	Description / reference
`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

Column history across versions

Column	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
`name`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`version`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`installed`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`superuser`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`relocatable`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`schema`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`requires`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`comment`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`trusted`	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●
`location`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 3

Definition snapshot: english-manuals:b1c82411fbe5b2db38c18f24276… · English manual source