On 2022-Apr-06, Tom Lane wrote:
> However, I very often find myself resorting to the much more tedious
>
> select * from pg_settings where name like '%foo%';
>
> when I want to see some related parameters, or when I'm a bit
> fuzzy on the exact name of the parameter.
Been there many times, so +1 for the general idea.
> In the discussion about adding privileges for GUCs [1], there
> was a proposal to add a new psql backslash command to show GUCs,
> which could reduce this problem to something like
>
> \dcp *foo*
+1. As for command name, I like \show as proposed by Pavel.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/