Re: Include extension path on pg_available_extensions

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Include extension path on pg_available_extensions
Date: 2025-11-02 15:11:43
Message-ID: 20251102151143.GU10642@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bryan Green 2025-11-02 15:29:43 Re: C nitpick about pgwin32_dispatch_queued_signals()
Previous Message Ranier Vilela 2025-11-02 14:59:35 Avoid overflow (src/backend/utils/adt/formatting.c)