diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2022-04-13 15:03:58 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2022-04-13 15:03:58 -0400 |
| commit | 139d46ee26a2c7813d02739d35fa305890643ac1 (patch) | |
| tree | 19d791950497c4e8b52ded0eab0e72bb0e053be8 | |
| parent | 7b7ed046cb2ad9f6efac90380757d5977f0f563f (diff) | |
| download | postgresql-139d46ee26a2c7813d02739d35fa305890643ac1.tar.gz postgresql-139d46ee26a2c7813d02739d35fa305890643ac1.zip | |
Further tweak the default behavior of psql's \dconfig.
Define "parameters with non-default settings" as being those that
not only have pg_settings.source different from 'default', but
also have a current value different from the hard-wired boot_val.
Adding the latter restriction removes a number of not-very-interesting
cases where the active setting is chosen by initdb but in practice
tends to be the same all the time.
Per discussion with Jonathan Katz.
Discussion: https://postgr.es/m/YlFQLzlPi4QD0wSi@msg.df7cb.de
| -rw-r--r-- | src/bin/psql/describe.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 1a2c6bc7f5b..839f1add900 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -4408,7 +4408,8 @@ describeConfigurationParameters(const char *pattern, bool verbose, NULL, "pg_catalog.lower(s.name)", NULL, NULL); else - appendPQExpBufferStr(&buf, "WHERE s.source <> 'default'\n"); + appendPQExpBufferStr(&buf, "WHERE s.source <> 'default' AND\n" + " s.setting IS DISTINCT FROM s.boot_val\n"); appendPQExpBufferStr(&buf, "ORDER BY 1;"); |