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

From Dean Rasheed
Subject Re: Psql meta-command conninfo+
Date
Msg-id CAEZATCXtKEonv53OUZpAhcMG2MmqFejuEKPaKS8ZwncF45E81g@mail.gmail.com
Whole thread Raw
In response to Re: Psql meta-command conninfo+  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Psql meta-command conninfo+
List pgsql-hackers
On Mon, 13 Jan 2025 at 08:44, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> > IMO, we should continue with v35 and add all parameters from
> > PQparameterStatus,
> > as Sami suggested. The names themselves are informative enough.
>
> IMO we need more opinions.  Maybe enough other people are not as unhappy
> about the three-table solution.
>

I don't like the 3-table format either. I think it should be a single table.

The trouble with v35 is that it produces 1 row with lots of columns,
which is pretty unreadable unless expanded mode is used. So I think we
should just do it that way round by default -- i.e., make it like
\dconfig and have 2 columns, "Parameter" and "Value", with lots of
rows.

Perhaps it could also have a "Description" column, which might help
with things like distinguishing between authenticated user and session
user.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Skip collecting decoded changes of already-aborted transactions
Next
From: Alena Rybakina
Date:
Subject: Re: Vacuum statistics