On Fri, 10 Jan 2025 20:37:17 +0800 Julien Rouhaud <rjuju...@gmail.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 <nag...@sraoss.co.jp>