On 4/9/22 11:58 AM, Julien Rouhaud wrote:
On Sat, Apr 09, 2022 at 10:31:17AM -0400, Tom Lane wrote:Christoph Berg <m...@debian.org> writes:I would think that if \dconfig showed the non-default settings only, it would be much more useful; the full list would still be available with "\dconfig *". This is in line with \dt only showing tables on the search_path, and "\dt *.*" showing all.Hm, I could get on board with that -- any other opinions?+1 for it, that's often what I'm interested in when looking at the GUCs in general.
-1, at least for the moment. Sometimes a user doesn't know what they're looking for coupled with being unaware of what the default value is. If a setting is set to a default value and that value is the problematic setting, a user should be able to see that even in a full list.
(The \dt searching only tables "search_path" vs. the database has also bitten me too. I did ultimately learn about "\dt *.*", but this makes the user have to unpack more layers to do simple things).
Jonathan
OpenPGP_signature
Description: OpenPGP digital signature
