PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSION_VERSIONS displays the extension versions of certain database features.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        Name  | 
      
        Name  | 
      
        Extension name  | 
     
| 
        version  | 
      
        Text  | 
      
        Version name  | 
     
| 
        installed  | 
      
        boolean  | 
      
        The value is true if the version of this extension is currently installed.  | 
     
| 
        superuser  | 
      
        boolean  | 
      
        The value is true if only system administrators are allowed to install this extension.  | 
     
| 
        relocatable  | 
      
        boolean  | 
      
        The value is true if an extension can be relocated to another schema.  | 
     
| 
        schema  | 
      
        Name  | 
      
        Name of the schema that the extension must be installed into. The value is NULL if the extension is partially or fully relocatable.  | 
     
| 
        requires  | 
      
        name[]  | 
      
        Names of prerequisite extensions. The value is NULL if there are no prerequisite extensions.  | 
     
| 
        comment  | 
      
        Text  | 
      
        Comment string from the extension's control file  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.