Re: Include extension path on pg_available_extensions

Michael Banck <mbanck@gmx.net>

From: Michael Banck <mbanck@gmx.net>
To: Matheus Alcantara <matheusssilv97@gmail.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2025-11-02T15:11:43Z
Lists: pgsql-hackers
Hi,

On Mon, Sep 15, 2025 at 09:18:25PM -0300, Matheus Alcantara wrote:
> postgres=# select * from pg_available_extensions;
>   name   | default_version | installed_version |                     comment                      |                  location
> ---------+-----------------+-------------------+--------------------------------------------------+---------------------------------------------------
>  envvar  | 1.0.0           |                   | Get the value of a server environment variable   | /usr/local/my/extensions/share/postgresql/extension
>  amcheck | 1.5             |                   | functions for verifying relation integrity       | $system
>  bloom   | 1.0             |                   | bloom access method - signature file based index | $system

I am not sure just adding the column at the end is best, I would have
put it before comment so that stays last, maybe somebody else has some
bikeshedding input here?


Michae