Re: psql: Add role's membership options to the \du+ command
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
Pavel Luzanov <p.luzanov@postgrespro.ru>, David Zhang <david.zhang@highgo.ca>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2023-04-04T17:29:10Z
Lists: pgsql-hackers
On Tue, Apr 4, 2023 at 1:12 PM Tom Lane <tgl@sss.pgh.pa.us> wrote: > I wonder if, while we're here, we should apply the idea of > joining-with-newlines-not-commas to the attributes column too. > That's another source of inconsistency in the proposed display. That would make the column narrower, which might be good, because it seems to me that listing the memberships could require quite a lot of space, both vertical and horizontal. There can be any number of memberships, and each of those memberships has a grantor and three flag bits (INHERIT, SET, ADMIN). If some user with a long username has been granted membership with all three of those flags by a grantor who also has a long username, and if we show all that information, we're going to use up a lot of horizontal space. And if there are many such grants, also a lot of vertical space. -- Robert Haas EDB: http://www.enterprisedb.com
Commits
-
Add psql \drg command to display role grants.
- d65ddaca93f6 17.0 landed
- 0a1d2a7df852 16.0 landed