Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYNyX-00FiwG-Vi for pgsql-hackers@arkaria.postgresql.org; Fri, 09 Feb 2024 10:19:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rYNyU-007r0p-Vp for pgsql-hackers@arkaria.postgresql.org; Fri, 09 Feb 2024 10:19:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYNyT-007r0h-Rk for pgsql-hackers@lists.postgresql.org; Fri, 09 Feb 2024 10:19:14 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rYNyP-006HbT-Qp for pgsql-hackers@postgresql.org; Fri, 09 Feb 2024 10:19:12 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 72DD05C0198; Fri, 9 Feb 2024 05:19:06 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Fri, 09 Feb 2024 05:19:06 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1707473946; x= 1707560346; bh=L7H9tzjzoHFP24rCRzQfDOdbZenAdwxecfstep/3mjs=; b=n sZYqrKAc/w6XcxSc9lR/dCwrGaK52vI8YW9r+vU6Z0DRVkftragnmHuYgmqZLl4f LtcHSVgbHXBOOnbo4iq8BFKaFNlAKDyyfdb7B7CdB/THv2GhFbGc5aAVH9bL8Q1+ dMw8CPysJe8g1fb1GAcq8NZ8ABrUo7o21nsbRCXvQxlvtrkycDDVjImaNaDUcjy4 p8SbmyH8b0yR/5Ujmz1yJYPVPYKEraVul/OSRa83Ia0o4UN6Xcg38AeieNj1Xnop JjwmZw2Nv8BWKUDITATaqcR1Hr2MhxG6+IPfPL698lPVQlmIGs7CzTQfVBIRpmXL mPyrLSGTrh6t23XFHZ5bQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrtdeigddufecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeff gfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 9 Feb 2024 05:19:05 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1707473943; bh=7QRSwyYTYp1uGbJGx0eUTwmMMoXLpZM2w3l32aDArxQ=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=lDEIjrlT+TpB/V+oy6+h9oMMEqv4/vA53Ozqrv0joTR4HZp1rTdHqPuhk0je6BBTJ SOnme+9Zl1dgUJadUnodG9llDLhTeysAR90iqygHOlBfyjY0+WQlgP3XtX+HuNDKIO inx5oovvQdcetQYaoh8Krkd20ph6ffyV1EaohhkFmsKyBdPFE+iczOGqPIFjhz+7xk asCQ1xqnUxxz9meiG1isve6B/ocylUefbWS9axDBvt2fmyDl/63MrRPWkV183fJkqr JNqlnXEQF//9TVnaWK746D9Mhm7iY2qXFvNwwb4dHeQWtXft/uDq7jY/v+NEgk2jvt fVhkfbhepJPwA== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 0F77FBA3; Fri, 9 Feb 2024 11:19:03 +0100 (CET) Date: Fri, 9 Feb 2024 11:19:03 +0100 From: Alvaro Herrera To: Maiquel Grassi Cc: Erik Wienhold , Jim Jones , Pavel Luzanov , Nathan Bossart , "pgsql-hackers@postgresql.org" Subject: Re: Psql meta-command conninfo+ Message-ID: <202402091019.y3psh2m7sqbv@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hmm, I noticed that this would call printSSLInfo() and printGSSInfo() after listConnectionInformation. It would be much better to show these in tabular format as well and remove the calls to printSSL/GSSInfo. I propose additional columns to the same \conninfo+ table; when SSL, like this: Database           | postgres [...] Host               | 127.0.0.1 Encryption | SSL Protocol | PQsslAttribute(protocol) Cipher | PQsslAttribute(cipher) Compression | PQsslAttribute(compression) When GSS, like this Database           | postgres [...] Host               | 127.0.0.1 Encryption | GSS (why don't we print anything else in printGSSInfo()? That's weird.) -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)