On 2024-Apr-04, Peter Eisentraut wrote: > But I don't really see the point of this. The information you are querying > is already available in various system views. This proposal is just a > shorthand for a collection of various random things some people like to see. > Like, by what reason is application name included as connection info? Why > not any other session settings? What about long-term maintenance: By what > logic should things be added to this?
Usability is precisely the point. You could also claim that we don't need \dconfig, since you could get the same thing by querying pg_settings for non-default settings. But \dconfig is very handy. I expect \conninfo+ to be equally useful. We don't give up command history just on the grounds that you can obtain the same effect by retyping the command. I'm not sure to what extent is it useful to make a distinction between the values that the client knows from those that the server knows. If it is, then we can redefine \conninfo+ to use the client values. The point about application_name is a valid one. I guess it's there because it's commonly given from the client side rather than being set server-side, even though it's still a GUC. Arguably we could remove it from \conninfo+, and claim that nothing that shows up in \dconfig should also appear in \conninfo+. Then users should get in the habit of using both to obtain a full picture. This sounds to me a very good compromise actually. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ Tom: There seems to be something broken here. Teodor: I'm in sackcloth and ashes... Fixed. http://postgr.es/m/482d1632.8010...@sigaev.ru