Re: How about a psql backslash command to show GUCs? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: How about a psql backslash command to show GUCs?
Date
Msg-id 202204061758.leffczewl4kd@alvherre.pgsql
Whole thread Raw
Responses Re: How about a psql backslash command to show GUCs?  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: SQL/JSON: JSON_TABLE
Next
From: Mark Dilger
Date:
Subject: Re: How about a psql backslash command to show GUCs?