On 16.04.2024 01:06, David G. Johnston wrote:
At this point I'm on board with retaining the \dr charter of simply being an easy way to access the detail exposed in pg_roles with some display formatting but without any attempt to convey how the system uses said information. Without changing pg_roles. Our level of effort here, and degree of dependence on superuser, doesn't seem to be bothering people enough to push more radical changes here through and we have good improvements that are being held up in the hope of possible perfection.
I have similar thoughts.
I decided to wait for the end of feature freeze and propose a simpler version
of the patch for v18, without changes in pg_roles.
I hope to send a new version soon.
But about \dr. Is it a typo and you mean \du & \dg?
If we were choosing a name for the command now, then \dr would be ideal:
\dr - display roles
\drg - display role grants
But the long history of \du & \dg prevents from doing so, and creating a third option is too excessive.
--
Pavel Luzanov
Postgres Professional: https://postgrespro.com