Re: How about a psql backslash command to show GUCs?

On 06.04.2022 20:48, Tom Lane wrote:
> However, I very often
> find myself resorting to the much more tedious
>
> select * from pg_settings where name like '%foo%';

> 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, great idea.

Right now I use the psql :show variable in my .psqlrc for this purpose:

=# \echo :show
SELECT name, current_setting(name) AS value, context FROM pg_settings\g 
(format=wrapped columns=100) | grep

=# :show autovacuum
  autovacuum                             | 
on                                    | sighup
  autovacuum_analyze_scale_factor        | 
0.1                                   | sighup
  autovacuum_analyze_threshold           | 
50                                    | sighup
  autovacuum_freeze_max_age              | 
200000000                             | postmaster
  autovacuum_max_workers                 | 
3                                     | postmaster
  autovacuum_multixact_freeze_max_age    | 
400000000                             | postmaster
  autovacuum_naptime                     | 
1min                                  | sighup
  autovacuum_vacuum_cost_delay           | 
2ms                                   | sighup
  autovacuum_vacuum_cost_limit           | 
-1                                    | sighup
  autovacuum_vacuum_scale_factor         | 
0.2                                   | sighup
  autovacuum_vacuum_threshold            | 
50                                    | sighup
  autovacuum_work_mem                    | 
-1                                    | sighup
  log_autovacuum_min_duration            | 
-1                                    | sighup

As for the name, I can't think of a better candidate. Any of the 
previously suggested list of \dconf, \dguc, \dG, \dcp is fine.

-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com
The Russian Postgres Company