Horton
Menu

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

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Joe Conway <mail@joeconway.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Mark Dilger <mark.dilger@enterprisedb.com>, Andrew Dunstan <andrew@dunslane.net>, David Rowley <dgrowleyml@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2022-04-07T17:04:19Z
Lists: pgsql-hackers 
On Thu, Apr 7, 2022 at 9:58 AM Joe Conway <mail@joeconway.com> wrote:

> On 4/7/22 12:37, Tom Lane wrote:
> > Mark Dilger <mark.dilger@enterprisedb.com> writes:
> >>> On Apr 7, 2022, at 9:29 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >>> I wouldn't
> >>> fight too hard if people want to lengthen it to \dconfig for
> consistency
> >>> with set_config().
> >
> >> I'd prefer \dconfig, but if the majority on this list view that as
> pedantically forcing them to type more, I'm not going to kick up a fuss
> about \dconf.
> >
> > Maybe I'm atypical, but I'm probably going to use tab completion
> > either way, so it's not really more keystrokes.  The consistency
> > point is a good one that I'd not considered before.
>
> Yeah I had thought about \dconfig too -- +1 to that, although I am fine
> with \dconf too.
>
>
\dconfig[+] gets my vote.  I was going to say "conf" just isn't common
jargon to say or write; but the one place it is - file extensions - is
relevant and common.  But still, I would go with the non-jargon form.

David J.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Be more careful about GucSource for internally-driven GUC settings.

  2. Fix case sensitivity in psql's tab completion for GUC names.

  3. Further tweak the default behavior of psql's \dconfig.

  4. Tweak the default behavior of psql's \dconfig.

  5. psql: add \dconfig command to show server's configuration parameters.

  6. Allow granting SET and ALTER SYSTEM privileges on GUC parameters.