Re: Adding extension default version to \dx
Julien Rouhaud <rjuju123@gmail.com>
From: Julien Rouhaud <rjuju123@gmail.com>
To: Magnus Hagander <magnus@hagander.net>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-10T12:37:17Z
Lists: pgsql-hackers
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.