Re: Psql meta-command conninfo+ - Mailing list pgsql-hackers

From Hunaid Sohail
Subject Re: Psql meta-command conninfo+
Date
Msg-id CAMWA6yYA96TsxZM3Z4Q4Z-COG215S7yCmdwwihu7CqvymUPXjA@mail.gmail.com
Whole thread Raw
In response to Re: Psql meta-command conninfo+  (Sami Imseih <samimseih@gmail.com>)
Responses Re: Psql meta-command conninfo+
List pgsql-hackers
Hi,

On Fri, Jan 10, 2025 at 1:50 AM Sami Imseih <samimseih@gmail.com> wrote:
> If we go with the 3 column format, then we will just
> have a bunch of repeated values for Category, which
> looks cluttered, IMO.

"cluttered" is maybe the wrong description. I meant the output
will look overwhelming due to the repeated values :)

+1.

To summarize:

- Alvaro is not happy with \conninfo+ printing multiple tables and suggests
we continue with v35.

- Sami is ok with both approaches but thinks that \conninfo+ should also
print all parameters from PQparameterStatus in a dynamic way. Also, he
suggests to include "role" if we are showing is_superuser.
For that, we need two more patches:
1. Mark role as GUC_REPORT with necessary doc changes.
2. Add a new libpq function (perhaps PQparameterNames) to return the names
of parameters, so we can also display parameters added in the future,
along with doc updates.

- David wants category information included.

IMO, we should continue with v35 and add all parameters from PQparameterStatus,
as Sami suggested. The names themselves are informative enough.

Looking forward to your feedback.

Regards,
Hunaid Sohail

pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Make pg_stat_io view count IOs as bytes instead of blocks
Next
From: Bertrand Drouvot
Date:
Subject: Re: Make pg_stat_io view count IOs as bytes instead of blocks