aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/bin/psql/describe.c3
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;");