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