Re: Adding extension default version to \dx

On Fri, 10 Jan 2025 20:37:17 +0800
Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:

> Hi,
>
> On Fri, Jan 10, 2025 at 01:04:14PM +0100, Magnus Hagander wrote:
> > In an effort to make at least a couple of more people realize they have to
> > run ALTER EXTENSION UPDATE after they've upgraded an extension, as well as
> > make it a bit easier to realize when you have to do it, I propose we add
> > the default version of an extension to \dx in psql.
>
> +1, I need the info very often and \dx is way faster than writing a query for
> that when I need it, especially since \dx output is not too big.
>
> > We currently show the
> > installed version in the schema, but no indications that a newer one might
> > be installed on the system.
> >
> > PFA a patch to do this.
>
> Patch LGTM, tested locally and I like the output.

I have a minor comment.

+ "LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name=e.extname "

For consistency with around codes, it seems better to add a space before and after "=",
like "ae.name = e.extname".

Regards,
Yugo Nagata

--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>