pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: psql: add \dconfig command to show server's configuration parame
Date: Thu, 07 Apr 2022 21:11:02 +0000
Message-ID: <E1ncZPB-000n2a-R2@gemulon.postgresql.org> (raw)

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

Plain \dconfig is basically equivalent to SHOW except that you can
give it a pattern with wildcards, either to match multiple GUCs or
because you don't exactly remember the name you want.

\dconfig+ adds type, context, and access-privilege information,
mainly because every other kind of object privilege has a psql command
to show it, so GUC privileges should too.  (A form of this command was
in some versions of the patch series leading up to commit a0ffa885e.
We pulled it out then because of doubts that the design and code were
up to snuff, but I think subsequent work has resolved that.)

In passing, fix incorrect completion of GUC names in GRANT/REVOKE
ON PARAMETER: a0ffa885e neglected to use the VERBATIM form of
COMPLETE_WITH_QUERY, so it misbehaved for custom (qualified) GUC
names.

Mark Dilger and Tom Lane

Discussion: https://postgr.es/m/3118455.1649267333@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/3e707fbb4009e9ac1d0e8b78b7af9f3f03f4cf1a

Modified Files
--------------
doc/src/sgml/ddl.sgml              |  2 +-
doc/src/sgml/ref/psql-ref.sgml     | 17 +++++++++++
src/bin/psql/command.c             |  9 +++++-
src/bin/psql/describe.c            | 62 ++++++++++++++++++++++++++++++++++++++
src/bin/psql/describe.h            |  4 +++
src/bin/psql/help.c                |  3 +-
src/bin/psql/tab-complete.c        |  7 +++--
src/fe_utils/string_utils.c        |  6 +++-
src/test/regress/expected/psql.out | 17 +++++++++++
src/test/regress/sql/psql.sql      |  6 ++++
10 files changed, 127 insertions(+), 6 deletions(-)



Message-ID: <E1ncZPB-000n2a-R2@gemulon.postgresql.org>
Permalink:  ../E1ncZPB-000n2a-R2@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1ncZPB-000n2a-R2@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us
  Subject: Re: pgsql: psql: add \dconfig command to show server's configuration parame
  In-Reply-To: <E1ncZPB-000n2a-R2@gemulon.postgresql.org>
  References: <E1ncZPB-000n2a-R2@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox