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