Re: Include extension path on pg_available_extensions

On Thu Oct 23, 2025 at 10:57 PM -03, Quan Zongliang wrote:
> On 10/23/25 9:56 PM, Euler Taveira wrote:
>
>> 
>> * insufficient privilege: if the role doesn't have the sufficient privileges,
>>    return NULL or '<insufficient privilege>' (similar to pg_stat_activity). I
>>    don't have a strong preference but the latter can impose more effort to use
>>    if you don't know the role has sufficient privilege. However, it is clear why
>>    the absolute path is not returned.
>> 
>
> +1
> I think this way is better.
>
So here it is, see attached.

I've created a new role pg_read_extension_paths for this, I'm not sure
if it's the best way to do this. I'm open for other ideas, perhaps we
can reuse some other role?

--
Matheus Alcantara