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 1rXTGa-00Apis-0V for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Feb 2024 21:46:08 +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 1rXTGY-006vAQ-3f for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Feb 2024 21:46:06 +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 1rXTGX-006vAH-On for pgsql-hackers@lists.postgresql.org; Tue, 06 Feb 2024 21:46:05 +0000 Received: from mail-roabra01olkn2108.outbound.protection.outlook.com ([40.92.96.108] helo=BRA01-ROA-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rXTGU-005pXm-TX for pgsql-hackers@postgresql.org; Tue, 06 Feb 2024 21:46:04 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=dji4ueoLpjMkNrUGexox4rNPxb+dc79tTSQy6W35Hsb6pEv2NMm1SsNRe7L47KMYQVA3jqbbDA4e0CoEKuCljYXjzyXu3ozEFVtWMHdWCk8ZyB3lUmUNUNA0+xPD0ow7n6bFIOpXy+BBH7OUi068B+eRNf5aJdxEM57HAlm7pTst4ah1GR8A9AJJDwGubKVe8MjsGiFAgJ+MvKjol2zXRQAiZI0L0WAzzaT8NjneNjQD7MQLNdIvDRt3x9pWogbIQKoIZxhI6UdLxsRT3wZSGDbhiIhvn6BVdib/N7YB2Gs/NW4z3sF6t/HiG0Kj4ltFPjJ3jZNKW2QAB+a36sm5gQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=/OkAeZlIsbfJwWlIURaGh6tcKn9XCyjg/vZowfwnU00=; b=AOCbxmWr2nI3xbazD7YzGjvzDPBExq1gTWpvAEHdwMQVrN1FceZYB9tXdXVqusthHDHGlF77x8fXpIygB6+JHfQ+/w0UCxeZMUDeJrpWym143ME+OWKXugzXfqKbvpUGCAJ9CGfhcoUpltqHErlyQlt+cEsqwChVvwzb0FV9PsMd609eRz/onEIY2q0ZG3DyQNVYt+u0UC21POfCMxaK99J9wjaaWzYlta3IEmjICm/cHMmmO7dOxEcTYuLQBnKnL2ocDX3FAwElT4qjZEqHkia258G61LQYrjgdBBtSv4MSt7Oni5QuHj5+nGWDkLprKiTilXng482cwQlwpVyF5g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none Received: from CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM (2603:10d6:103:2dc::11) by CP8P284MB2387.BRAP284.PROD.OUTLOOK.COM (2603:10d6:103:1e7::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7249.36; Tue, 6 Feb 2024 21:45:54 +0000 Received: from CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM ([fe80::ce6:bf75:3d4a:97cf]) by CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM ([fe80::ce6:bf75:3d4a:97cf%6]) with mapi id 15.20.7249.035; Tue, 6 Feb 2024 21:45:54 +0000 From: Maiquel Grassi To: Nathan Bossart CC: Erik Wienhold , "pgsql-hackers@postgresql.org" Subject: RE: Psql meta-command conninfo+ Thread-Topic: Psql meta-command conninfo+ Thread-Index: AQHaWRQuU7L2MD2CX0quiO/hLxQK8bD9n9eAgAAOagCAABlrgoAABsOAgAABrYCAAAkRMg== Date: Tue, 6 Feb 2024 21:45:54 +0000 Message-ID: References: <20240206181919.GA3853632@nathanxps13> <20240206210605.GA3903769@nathanxps13> <20240206211205.GA3903996@nathanxps13> In-Reply-To: <20240206211205.GA3903996@nathanxps13> Accept-Language: pt-BR, en-US Content-Language: pt-BR X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [hIf+fr3r/XNopd+2nebguUT56Zyb2iTQ] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CP8P284MB2496:EE_|CP8P284MB2387:EE_ x-ms-office365-filtering-correlation-id: df3c4aab-e2f3-4865-37b9-08dc275cfefc x-ms-exchange-slblob-mailprops: 9qw5+ftluCAG+PuFHzR7/nRm3kPI3FWfqAXeJspsXmquodoFli17IbGuuPJfSkpEeJxZlwJ2ggy0HLSoKYsuaIrxZSMHT0EPaGk6s6zylzG922z7fM9/CoMGLpveqig2EfNOoBOl1hJz3JXIZCw8gmklMhxWVxmzQki1Je0gmx8JyJggxSJOrwwcD+I6Qn/2AqT041i85410izGJTN3C94JTH2itWhLAbhoET+dus/i4X/sf7LzlO18RG48/BzWLH0Ro1Pi0c+CvFl7DKgZ+ABBoVX9PkQwdMQPmfgAznoZm3W52gMmt4u2ROynpI3RTKxxinwgu0G4XIlnx15eaIyRUT6iR//ZZMGORmhkfocKclboEy0FyuoLYw0gEit1mp8j4UrAa39QVIkDgiIGQYUXcXEeRvuuoMA16gwDyRjrRyQNS21iXfjhEmI5a5CzI8O74KLKxUGANtpKNcmTBqdEIVUBEH4Iz0l/6ZO9cWX8UtpfH3TfHHpSo4MhnlWnR6tmIM3NQz/HNMnNgyo+p/xIKVL6CBQeAFTwYOyT+D9ZtjvNCQJ33wbjIiP4zswtT4T6HG4dMXb6AWd28xvex7eEZtWEmtnRWks2V2SaNL+8WisnMUAGDHhNvD+VdiAU2AhA5zhYPIzif76i636DYzEi+IHotjwscQT7+Ybpd8wMvs1g/IKz1Zfo6L9RhsOneXGVbBFCs0ts= x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ZMpIf+gaJY4iVO+KzeFq39RAgagetgq7097rawbwSIb1hu4rqFt+g0Sn76PhS1QTI3uRYRjt1fWFOcMoCo3zytU2mFjfGSCz+BenSCwTpcA06Jo4XSmNl2tooa/SUARDveyHVgGepOOabBtXeMfIFE7GVimJwoGMY94y5ow9I1WVQiUy0ioEnUjQ8cFY0M7sRFsCws40Ug9eimX6n4S5nUb3RX8ZZf3KCWu2kB84QbYpIBFJiGPNTC1UZEbqDHBWX0/MBtMxC0NlJZM9KXTV0kyxMdxhHCn2iZssCcs9eAS0JFN/dItDYY6N88si+2WC0P34hiSO7HCvVziMj+Lo3w/xDm5LURBiAExKHz1SaC/yrObha88LY0vd+6weFpY7sjGviXc2r1qmLH4A9jfAYgANwkRPj4D2wCfoKkxsevWieJCQV1nC0cNndbMxA2R56co8TeSMkyJUee19OQm3+oGkC8RI/PgN4iDpF1EtEUXBpIH/Dd3EgaooYPkDeP42n2Fr6WOxSnT+pi0bto8sehdcuXNW7WtGg192QyeysWQ/0q89sVEcUPP5wVm3zbL8 x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?3StTXdWQZjD8UuvyxwHXPTomXO+HT74fY4sZ1nVuU7qpV6Js71ZmimySEm?= =?iso-8859-1?Q?SuexWhl8UvShk2X3wZ31TW1YQlYD3dinbaSMUHHwD/OE5SEUztkqaazqfw?= =?iso-8859-1?Q?n71ufoWJaO5sNkVZDAqzdgZUQB3Kh55mFhNTC3QnwW03Jrbdpdb6jzvx6u?= =?iso-8859-1?Q?cdzgmghEhJB+tLUIad22WE2NaS62tWZvX7EKEC8ghAtBc/VdRFYzyMn604?= =?iso-8859-1?Q?IY8fa3FjQyrOyJX3k44UbdX+0vVnw9jI5G9UcGRwMd7NDrsq5gFNfmrNxa?= =?iso-8859-1?Q?kVDcEKEgiIp5Os5e5HOOm2s5H6H6cM5nob8epo01tpmIQn4dWdq8K3vPT0?= =?iso-8859-1?Q?F0pi9LNSqAMN1y/J1YCmtWqQzp0rUTF59niGWwwO13b+R1o1lj0s0wF5jK?= =?iso-8859-1?Q?PS4j+3CeCHxjqtQ/2OP/IC9LvqFId77rDQD8Y5Bp22sG5b5hCwzVQfF6r6?= =?iso-8859-1?Q?CSWfUkQmRvHjxIlnzlx97DYubC+S6Vp+XrjYNB1llF2ayt1R8BZbGCNj6u?= =?iso-8859-1?Q?9q1orHIpU5+J9DbqfxVHT16paCoSmBg4lE8sZNyNmCKOJbt4rpoJlFqgWY?= =?iso-8859-1?Q?CnB1dxOnxcTxRLo41ThtPq5J9txmpVcejpM79euhDSG+UdDW3ZPLEXA2w/?= =?iso-8859-1?Q?E7+W3LfNOBC+6uw4yhTG5A1FM79n7RO5bZuSHNUnAWTRb5gbttKtq+opMe?= =?iso-8859-1?Q?NY6teWrH0c+YUOtWPKQSTTrW/Icx2DZYVIDl/YZK8cAh2dg4KLFrCpd0rR?= =?iso-8859-1?Q?ACbT05sH23lIdhKq/U1EWBfiQ0WDLtwYJnoTN+jtu+UG0kwMJ0bWdDM57M?= =?iso-8859-1?Q?ze1weMT70d/nJN0xhrSY8Oq9AINJDw38ojQ2QcqVg7Hl4eod47hv4QpNxO?= =?iso-8859-1?Q?9vTTn0NhCKp8Bj3SU/GEt0uF+0dQXjAq2Ymtzaced/qzbvmMxa4nSEJtnl?= =?iso-8859-1?Q?t6o7f9bopHVsBZQC5tNgNBAxuZi+NFJHXxoIl2OrrorThT4pst8ZSPLAOY?= =?iso-8859-1?Q?Tn1CrRld9HEWP4fBnwSICOXCESdDEoMxiopZHYT3Vefk6yfphXMcGkyHCn?= =?iso-8859-1?Q?wZSTluc0JS2Pa9a8JCMki506ilZGHHDIY9qKDCuSN9TMfKgItE0Ls8/N9E?= =?iso-8859-1?Q?H2E3FBVdWoWpWA2Y+4b4MBM8ANSx1fC1T6RZshdkgTmmVj0+S/HDCeQNE/?= =?iso-8859-1?Q?PVCpW/eHTSmzH+CTzzizity8AD/Z0rF3fIv5dVBb4hOspjeddRojg7vZQ7?= =?iso-8859-1?Q?JpawaLRXNzHxU6hvjgvw=3D=3D?= Content-Type: multipart/alternative; boundary="_000_CP8P284MB24965479BA59DF5C2CC01CA0EC462CP8P284MB2496BRAP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-7dc52.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: df3c4aab-e2f3-4865-37b9-08dc275cfefc X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Feb 2024 21:45:54.8077 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: CP8P284MB2387 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CP8P284MB24965479BA59DF5C2CC01CA0EC462CP8P284MB2496BRAP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable On Tue, Feb 06, 2024 at 03:06:05PM -0600, Nathan Bossart wrote: > On Tue, Feb 06, 2024 at 08:52:09PM +0000, Maiquel Grassi wrote: >> I made the adjustment in the code and updated the patch. I believe thi= s >> is the format suggested by you all. Would this be it? > > I was thinking something more like > > SELECT pg_catalog.current_database() AS "Database", > current_user AS "User", > pg_catalog.current_setting('server_version') AS "Server Versio= n", > pg_catalog.inet_server_addr() AS "Server Address", > pg_catalog.current_setting('port') AS "Port", > pg_catalog.inet_client_addr() AS "Client Address", > pg_catalog.inet_client_port() AS "Client Port", > pg_catalog.pg_backend_pid() AS "Session PID"; ... although that seems to be missing items like the socket directory and the host. --//-- My initial idea has always been that they should continue to appear because= \conninfo+ should show all the things that \conninfo shows and add more in= formation. I think that's the purpose of the 'plus.' Now we're on a better = path than the initial one. We can still add the socket directory and the ho= st. Regards, Maiquel O. Grassi. --_000_CP8P284MB24965479BA59DF5C2CC01CA0EC462CP8P284MB2496BRAP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
  On Tue, Fe= b 06, 2024 at 03:06:05PM -0600, Nathan Bossart wrote:
  > On Tue, Feb 06, 2024 at 08:52:09PM +0000, Maiquel Grassi wrote:=
  >> I made the adjustment in the code and updated the patch. I = believe this
  >> is the format suggested by you all. Would this be it?
  >
  > I was thinking something more like
  >
  >   SELECT pg_catalog.current_database() AS "Datab= ase",
  >          current_u= ser AS "User",
  >          pg_catalo= g.current_setting('server_version') AS "Server Version",
  >          pg_catalo= g.inet_server_addr() AS "Server Address",
  >          pg_catalo= g.current_setting('port') AS "Port",
  >          pg_catalo= g.inet_client_addr() AS "Client Address",
  >          pg_catalo= g.inet_client_port() AS "Client Port",
  >          pg_catalo= g.pg_backend_pid() AS "Session PID";
 
  ... although that seems to be missing items like the socket director= y and
  the host.

--//--

My initial idea has always been that they should continue to appear be= cause \conninfo+ should show all the things that \conninfo shows and add more information. I think that's the purpose = of the 'plus.' Now we're on a better path than the initial one. We can stil= l add the socket directory and the host.

Regards,
Maiquel O. Grassi.
--_000_CP8P284MB24965479BA59DF5C2CC01CA0EC462CP8P284MB2496BRAP_--