MIME-Version: 1.0
References: <CAMWA6yYA96TsxZM3Z4Q4Z-COG215S7yCmdwwihu7CqvymUPXjA@mail.gmail.com>
 <202501130844.yu2rovbwkl2u@alvherre.pgsql>
In-Reply-To: <202501130844.yu2rovbwkl2u@alvherre.pgsql>
From: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: Mon, 13 Jan 2025 11:12:23 +0000
Message-ID: <CAEZATCXtKEonv53OUZpAhcMG2MmqFejuEKPaKS8ZwncF45E81g@mail.gmail.com>
Subject: Re: Psql meta-command conninfo+
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Hunaid Sohail <hunaidpgml@gmail.com>, Sami Imseih <samimseih@gmail.com>, 
	"David G. Johnston" <david.g.johnston@gmail.com>, Maiquel Grassi <grassi@hotmail.com.br>, 
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Jim Jones <jim.jones@uni-muenster.de>, 
	Tom Lane <tgl@sss.pgh.pa.us>, Nathan Bossart <nathandbossart@gmail.com>, 
	"Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, 
	Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CAEZATCXtKEonv53OUZpAhcMG2MmqFejuEKPaKS8ZwncF45E81g%40mail.gmail.com>
Precedence: bulk

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