On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier <michael@xxxxxxxxxxx> wrote: >> >> On Wed, Sep 23, 2020 at 03:28:45PM +0000, Daniel Westermann (DWE) wrote: >> > I was playing a bit with trusted extensions and wondered if there is >> > a reason that the "trusted" flag is not exposed in pg_available_extensions. >> > I believe that information would be quite useful so one can easily >> > identify extensions that can be installed as "normal" user. >> >> Adding the trusted flag makes sense for visibility. There is a bit >> more that we could consider though? For example, what about >> "relocatable" and "requires"? >+1, and also the schema (for non relocatable extensions). +1