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 1puFNN-0001qT-51 for pgsql-hackers@arkaria.postgresql.org; Wed, 03 May 2023 16:30:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1puFNM-0006NN-3Y for pgsql-hackers@arkaria.postgresql.org; Wed, 03 May 2023 16:30:44 +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 1puFNL-0006NA-QQ; Wed, 03 May 2023 16:30:43 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1puFNJ-000NDd-Bo; Wed, 03 May 2023 16:30:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=7Xyjm9Rdw/vef7oksejBwpIoFSlBMJe78X6s+C5RY+g=; b=f1eTV0l0Na7SmHwsdy/JYB2ZJ8 CB8UuRKoimfFQtZS9U+BGoJPjfBPsqGJaP+chjBXmBnUtfBa/4wYZyteLS2GDZ/iduq+5VGZ5q3nq aaJPB3dFyyPL8xRlA0x4ZJoQ7Uf5BSxk0NeLjMKh0TtPuWJtWDx7y5o1K6eXrAzOeDeq+Y1E6ZfM7 8PHWGT23875B3Gn/YikenjhlG4OZC/JUyY/tn2lFNNGeEvkGZTv0YVBxTxh83LoKjkk6tgZL+VYhr yp+a23jGkTkBP8LAzlzkbZyXo6mn4kyqlU5wYfIVpWAyZH/Mdb6qHWWLDK8zIKgb5lCS2vLcsJdYM ViBq8pgQ==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1puFNE-000moO-6g; Wed, 03 May 2023 16:30:39 +0000 Message-ID: Date: Wed, 3 May 2023 12:30:34 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.9.1 Subject: Re: psql: Add role's membership options to the \du+ command Content-Language: en-US To: Tom Lane , "David G. Johnston" Cc: Pavel Luzanov , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org References: <42678ca5-f3c6-db1b-e0c5-c63c3ce8997e@postgrespro.ru> <1525117.1680628353@sss.pgh.pa.us> <1575395.1680629866@sss.pgh.pa.us> <1831161.1680703111@sss.pgh.pa.us> <9ada7371-e! c98-ae25-aa37-30c0d4b08613@postgresql.org> <2977612.1683131109@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: <2977612.1683131109@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------QJ3PdYULR5ox3pM4JMnunPDM" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------QJ3PdYULR5ox3pM4JMnunPDM Content-Type: multipart/mixed; boundary="------------KZMQPYQDH0jeaqdsGlBl27fs"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane , "David G. Johnston" Cc: Pavel Luzanov , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org Message-ID: Subject: Re: psql: Add role's membership options to the \du+ command References: <42678ca5-f3c6-db1b-e0c5-c63c3ce8997e@postgrespro.ru> <1525117.1680628353@sss.pgh.pa.us> <1575395.1680629866@sss.pgh.pa.us> <1831161.1680703111@sss.pgh.pa.us> <9ada7371-e! c98-ae25-aa37-30c0d4b08613@postgresql.org> <2977612.1683131109@sss.pgh.pa.us> In-Reply-To: <2977612.1683131109@sss.pgh.pa.us> --------------KZMQPYQDH0jeaqdsGlBl27fs Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNS8zLzIzIDEyOjI1IFBNLCBUb20gTGFuZSB3cm90ZToNCj4gIkRhdmlkIEcuIEpvaG5z dG9uIiA8ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20+IHdyaXRlczoNCj4+IE9uIFdlZCwg TWF5IDMsIDIwMjMgYXQgOTowMOKAr0FNIEpvbmF0aGFuIFMuIEthdHogPGprYXR6QHBvc3Rn cmVzcWwub3JnPg0KPj4gd3JvdGU6DQo+Pj4gSSBkb24ndCBzZWUgd2h5IHRoaXMgaXMgYW4g b3BlbiBpdGVtIGFzIHRoaXMgZmVhdHVyZSB3YXMgbm90IGNvbW1pdHRlZA0KPj4+IGZvciB2 MTYuIE9wZW4gaXRlbXMgdHlwaWNhbGx5IHJldm9sdmUgYXJvdW5kIGNvbW1pdHRlZCBmZWF0 dXJlcy4NCj4gDQo+PiBUaGUgYXJndW1lbnQgaXMgdGhhdCB1cGRhdGluZyB0aGUgcHNxbCBc ZCB2aWV3cyB0byBzaG93IHRoZSBuZXdseSBhZGRlZA0KPj4gb3B0aW9ucyBpcyBzb21ldGhp bmcgdGhhdCB0aGUgcGF0Y2ggdG8gYWRkIHRob3NlIG9wdGlvbnMgc2hvdWxkIGhhdmUgZG9u ZQ0KPj4gYmVmb3JlIGJlaW5nIGNvbW1pdHRlZC4NCj4gDQo+IFllYWgsIGlmIHRoZXJlIGlz IG5vdCBhbnkgY29udmVuaWVudCB3YXkgdG8gc2VlIHRoYXQgaW5mbyBpbiBwc3FsDQo+IHRo ZW4gdGhhdCBzZWVtcyBsaWtlIGEgbWlzc2luZyBwYXJ0IG9mIHRoZSBmZWF0dXJlLg0KDQpb Uk1UIGhhdF0NCg0KT0sgLS0gSSB3YXMgcmVyZWFkaW5nIHRoZSB0aHJlYWQgYWdhaW4gdG8g c2VlIGlmIEkgY291bGQgZ2xlYW4gdGhhdCANCmluc2lnaHQuIFRoZXJlIHdhcyBhIGNvbW1l bnQgYnVyaWVkIGluIHRoZSB0aHJlYWQgd2l0aCBEYXZpZCdzIG9waW5pb24gDQpvbiB0aGF0 IGZyb250LCBidXQgbm8gb25lIGhhZCArMSdkIHRoYXQuDQoNCkhvd2V2ZXIsIGlmIHRoaXMg aXMgZm9yIGZlYXR1cmUgY29tcGxldGVuZXNzLCBJJ2xsIHdpdGhkcmF3IHRoZSBjbG9zaW5n IA0Kb2YgdGhlIG9wZW4gaXRlbSwgYnV0IHdvdWxkIHN0cm9uZ2x5IHN1Z2dlc3Qgd2UgY29t cGxldGUgaXQgaW4gdGltZSBmb3IgDQpCZXRhIDEuDQoNCltQZXJzb25hbCBoYXRdDQoNCkxv b2tpbmcgYXQgUGF2ZWwncyBsYXRlc3QgcGF0Y2gsIEkgZG8gZmluZCB0aGUgb3V0cHV0IGVh c3kgdG8gDQp1bmRlcnN0YW5kLCB0aG91Z2ggZG8gd2UgbmVlZCB0byBleHBsaWNpdGx5IGxp c3QgImVtcHR5IiBpZiB0aGVyZSBhcmUgbm8gDQptZW1iZXJzaGlwIHBlcm1pc3Npb25zPw0K DQpUaGFua3MsDQoNCkpvbmF0aGFuDQo= --------------KZMQPYQDH0jeaqdsGlBl27fs-- --------------QJ3PdYULR5ox3pM4JMnunPDM Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmRSjCoFAwAAAAAACgkQ8QSccp8cZScr gw/7Bj96yCFvwDzwqnW8Ne3W2uE2NThYMUM9ohwX6AKQTidwcltuUgPovtphDGc1JeVp4+1Zd6zh fVtZrEuf7EP09aeDr5y5a1aC1Hyf0+2wf4K/0OMvV98DwBfhVut5fpVpZNYf6511kEaOrr8JpzM/ 1ilAzn7xzfXS3PF7ewNT6w3ThHp0eW7u73Y1lgMvKdyz3vzpeSHagp7KuU47I6SQrP01M9w+sphi WpV1KhNEs25ECDa6UBqSydTaC33i0BBHYP4x6NQEX2/R6ogMtHPG9PhYXUXF4BifQdKUAd45TvA6 AQP6z1XDv0lCwOJaohc/sFTIheBvBZW8q3039zoLB0Xq0UgcqSYZbpZhP6Tzg+RS6qsw+LK/8z7o 7yVJT+Kn0YhPCkTZJcuTWCa4wUxVHi1/R2yCUphaw7uNFSZTtYkExGE/SGosTD1UOHq5soRb3iNw 8s3NR6413i0nRZzcrw3ofZj03o0JUc/fwQLqoS0S7OyL7AEht5cw0/HrATHxSHTU++lFbWRDPtkh Pgtj2EfknHrt/4YoWD//RDFuegnpPLaUr446eMkjcvJrGdsWXi7XdOo6NJkoxYHDe7dsbrvvso1s T8nwi4Y8nrX21GFJKPjfhnjBpSmgBBCgBev37sfmBBJ9+colbysj4sniltpNo14jLy6leCnGU/ji 2AI= =DCR8 -----END PGP SIGNATURE----- --------------QJ3PdYULR5ox3pM4JMnunPDM--