Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Dilger <mark.dilger@enterprisedb.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, David Rowley <dgrowleyml@gmail.com>, Joe Conway <mail@joeconway.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2022-04-07T16:29:33Z
Lists: pgsql-hackers 
Mark Dilger <mark.dilger@enterprisedb.com> writes:
> We have too many synonyms for configuration parameters.  "config", "guc", "parameter", and "setting" are already in use.  I thought we agreed on the other thread that "setting" means the value, and "parameter" is the thing being set.

Right, so the suggestion of \dsetting seems a tad off-kilter.

> It's true that "config" refers to parameters in the name of pg_catalog.set_config, which is a pretty strong precedent, but sadly "config" also refers to configuration files, the build configuration (as in the "pg_config" tool), text search configuration, etc.

I'd also thought briefly about \dpar or \dparam, but I'm not sure that
that's much of an improvement.  \dconf is at least in line with the
docs' terminology of "configuration parameter".  (Note that bare
"parameter" has other meanings too, eg function parameter.)  I wouldn't
fight too hard if people want to lengthen it to \dconfig for consistency
with set_config().

			regards, tom lane

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.