Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSibX-0004gP-NY for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 18:03:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pSibW-0003sB-KV for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Feb 2023 18:03:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSibW-0003s2-4n for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 18:03:34 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pSibU-0003iR-2L for pgsql-hackers@lists.postgresql.org; Thu, 16 Feb 2023 18:03:33 +0000 Received: from [192.168.28.30] (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 72D4521CABB2; Thu, 16 Feb 2023 21:03:30 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1676570610; bh=NtxRIefO6lsG/5P7lkBZRLSPNEpcQRSQ/bWgTDH7CIk=; h=Date:Subject:To:Cc:References:From:In-Reply-To; b=CJ043O6rOUP6BXcLyvKLUuIG4dbS/D62M/e/uxa1/2/9oa/X63acJtOppoAFCk4j4 5ANlZgL+yaBew4HAfn7ZwAtKX1eDbkB4ogcUhlWozilpy4cbWYWgctIapxmewpe5BT v7Hbsr/WSlgvHmA6onPGsv44LkfwATs9oxJdKbC4= Content-Type: multipart/alternative; boundary="------------QhzM3NApH7ulqD42oWw5ozQ6" Message-ID: <01620d6b-9efe-b199-b619-8450d865ec83@postgrespro.ru> Date: Thu, 16 Feb 2023 21:03:29 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: psql: Add role's membership options to the \du+ command Content-Language: en-US, ru-RU To: "David G. Johnston" , David Zhang Cc: "pgsql-hackers@lists.postgresql.org" References: From: Pavel Luzanov In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------QhzM3NApH7ulqD42oWw5ozQ6 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 16.02.2023 00:37, David G. Johnston wrote: > I mean, either you accept the change in how this meta-command presents > its information or you don't. Yes, that's the main issue of this patch. On the one hand, it would be nice to see the membership options with the psql command. On the other hand, I don't have an exact understanding of how best to do it. That's why I proposed a variant for discussion. It is quite possible that if there is no consensus, it would be better to leave it as is, and get information by queries to the system catalog. ----- Pavel Luzanov --------------QhzM3NApH7ulqD42oWw5ozQ6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
On 16.02.2023 00:37, David G. Johnston wrote:
I mean, either you accept the change in how this meta-command presents its information or you don't.

Yes, that's the main issue of this patch.

On the one hand, it would be nice to see the membership options with the psql command.

On the other hand, I don't have an exact understanding of how best to do it. That's why I proposed a variant for discussion. It is quite possible that if there is no consensus, it would be better to leave it as is, and get information by queries to the system catalog.

-----
Pavel Luzanov
--------------QhzM3NApH7ulqD42oWw5ozQ6--