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 1pzTbT-0004gS-Mo for pgsql-hackers@arkaria.postgresql.org; Thu, 18 May 2023 02:42:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pzTbR-00038t-O5 for pgsql-hackers@arkaria.postgresql.org; Thu, 18 May 2023 02:42:53 +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 1pzTbR-00038e-7t; Thu, 18 May 2023 02:42:53 +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 1pzTbM-000SIy-00; Thu, 18 May 2023 02:42:52 +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=cJssH2lDeXGlkQFFdhHvDdNfCYiTokH2UWDr1NVlwRM=; b=P5OHKjFeNVXZU6FCWQEnc8zR02 Z5VipKN8R/eHM3K0HWvW6TYG1JnGdsxaoK11qU3m7kjUxk/On3g9W+qVAmpmxVUL82wSEb7CKEfph nHyPcxR50gbODQUBTKDJgf191Jx8UAJKpsaq0n9q5ZHHQ4wu6hoeGL9MqDbs3zG0HnUg9tzIvsv7w ZLa/bGjf3ni9vzgssDabUvxOPWZRYFSiNYgSWwuCghV3hPNQSDmXmM2jDbAouaDq1/meOhnKGOlRN 4MnQp3OyEImk8zEAvW/1hKwmoYXNPXH/Yn30UlfwzeKLCBFaUwRkazjbRVXXan0zMWelVXnm/lezW ulFgeV9w==; 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 1pzTbH-000yXR-BB; Thu, 18 May 2023 02:42:45 +0000 Message-ID: <6b64c59a-fe41-bb07-d0cd-856896412b00@postgresql.org> Date: Wed, 17 May 2023 22:42:40 -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: Pavel Luzanov , "David G. Johnston" Cc: Tom Lane , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org, horikyota.ntt@gmail.com 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> <2977612.1683131109@sss.pgh.pa.us> <39e7431c-1224-ab05-c67c-68f4cf625442@postgrespro.ru> From: "Jonathan S. Katz" In-Reply-To: <39e7431c-1224-ab05-c67c-68f4cf625442@postgrespro.ru> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------HsLr0vKNv2USYAQ0sz0703Zb" 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) --------------HsLr0vKNv2USYAQ0sz0703Zb Content-Type: multipart/mixed; boundary="------------xyV30OR5GTyAJinNv0QWKriz"; protected-headers="v1" From: "Jonathan S. Katz" To: Pavel Luzanov , "David G. Johnston" Cc: Tom Lane , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org, horikyota.ntt@gmail.com Message-ID: <6b64c59a-fe41-bb07-d0cd-856896412b00@postgresql.org> 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> <2977612.1683131109@sss.pgh.pa.us> <39e7431c-1224-ab05-c67c-68f4cf625442@postgrespro.ru> In-Reply-To: <39e7431c-1224-ab05-c67c-68f4cf625442@postgrespro.ru> --------------xyV30OR5GTyAJinNv0QWKriz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNS83LzIzIDM6MTQgUE0sIFBhdmVsIEx1emFub3Ygd3JvdGU6DQo+IE9uIDA1LjA1LjIw MjMgMTk6NTEsIERhdmlkIEcuIEpvaG5zdG9uIHdyb3RlOg0KPj4gQnV0IGlmIGl0IGlzIHJl YWxseSBhwqBibG9ja2VyIHRoZW4gbWF5YmUgd2Ugc2hvdWxkIHByb2R1Y2UgMyBzZXBhcmF0 ZSANCj4+IG5ld2xpbmUgc2VwYXJhdGVkIGNvbHVtbnMsIG9uZSBmb3IgdGhlIG1lbWJlciBv ZiByb2xlLCBvbmUgZm9yIHRoZSANCj4+IGxpc3Qgb2YgYXR0cmlidXRlcywgYW5kIG9uZSB3 aXRoIHRoZSBncmFudG9yLsKgIFRoZSBjb2x1bW4gaGVhZGVycyBjYW4gDQo+PiBiZSB0cmFu c2xhdGVkIG1vcmUgZWFzaWx5IGFzIHNpbmdsZSBub3Vucy7CoCBUaGUgcmVhZGFiaWxpdHkg cXVpdGUgDQo+PiBwcm9iYWJseSB3b3VsZCBlbmQgdXAgYmVpbmcgZXF1aXZhbGVudCAobWF5 YmUgZXZlbiBiZXR0ZXIpIGluIHRhYnVsYXIgDQo+PiBmb3JtIGluc3RlYWQgb2Ygc2VudGVu Y2UgZm9ybS4NCj4gDQo+IEp1c3QgdG8gdmlzdWFsaXplIHRoaXMgYXBwcm9hY2guIEJlbG93 IGFyZSB0aGUgb3V0cHV0IGZvciB0aGUgdGFidWxhciANCj4gZm9ybSBhbmQgdGhlIHNlbnRl bmNlIGZvcm0gZnJvbSBsYXN0IHBhdGNoIHZlcnNpb24gKHNxbCBzY3JpcHQgYXR0YWNoZWQp Og0KPiANCj4gVGFidWxhciBmb3JtwqDCoMKgwqAgcm9sbmFtZcKgwqDCoMKgwqAgfMKgwqDC oMKgIG1lbWJlcm9mwqDCoMKgwqAgfMKgwqDCoMKgwqDCoCBvcHRpb25zICAgICAgIA0KPiB8 wqDCoMKgwqAgZ3JhbnRvciANCj4gLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0twqBwb3N0Z3Jl c8KgwqDCoMKgwqDCoMKgwqAgfMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAg fMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCDCoHJlZ3Jlc3Nf ZHVfYWRtaW4gfCByZWdyZXNzX2R1X3JvbGUwK3wgYWRtaW4sIGluaGVyaXQsIHNldCt8IHBv c3RncmVzwqDCoMKgwqDCoMKgwqAgK8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqAgfCByZWdyZXNzX2R1X3JvbGUxK3wgYWRtaW4sIGluaGVyaXQsIHNldCt8IHBvc3RncmVz wqDCoMKgwqDCoMKgwqAgK8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCBy ZWdyZXNzX2R1X3JvbGUyIHwgYWRtaW4sIGluaGVyaXQsIHNldCB8IHBvc3RncmVzwqByZWdy ZXNzX2R1X3JvbGUwIHzCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHzCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgwqByZWdyZXNzX2R1X3Jv bGUxIHwgcmVncmVzc19kdV9yb2xlMCt8IGFkbWluLCBpbmhlcml0LCBzZXQrfCByZWdyZXNz X2R1X2FkbWluK8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCByZWdyZXNz X2R1X3JvbGUwK3wgaW5oZXJpdMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgK3wgcmVncmVzc19k dV9yb2xlMSvCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgcmVncmVzc19k dV9yb2xlMCB8IHNldMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgcmVncmVz c19kdV9yb2xlMsKgcmVncmVzc19kdV9yb2xlMiB8IHJlZ3Jlc3NfZHVfcm9sZTArfCBhZG1p bsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgICt8IHJlZ3Jlc3NfZHVfYWRtaW4rwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IHJlZ3Jlc3NfZHVfcm9sZTArfCBpbmhl cml0LCBzZXTCoMKgwqDCoMKgwqAgK3wgcmVncmVzc19kdV9yb2xlMSvCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgcmVncmVzc19kdV9yb2xlMCt8IGVtcHR5wqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqAgK3wgcmVncmVzc19kdV9yb2xlMivCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwgcmVncmVzc19kdV9yb2xlMSB8IGFkbWluLCBzZXTC oMKgwqDCoMKgwqDCoMKgwqAgfCByZWdyZXNzX2R1X2FkbWluKDUgcm93cylTZW50ZW5jZSBm b3JtIGZyb20gcGF0Y2ggdjfCoMKgwqDCoCByb2xuYW1lwqDCoMKgwqDCoCB8wqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBtZW1iZXJvZiAt LS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS3CoHBvc3RncmVzwqDCoMKgwqDCoMKgwqDCoCB8 IMKgcmVncmVzc19kdV9hZG1pbiB8IHJlZ3Jlc3NfZHVfcm9sZTAgZnJvbSBwb3N0Z3JlcyAo YWRtaW4sIGluaGVyaXQsIHNldCnCoMKgwqDCoMKgwqDCoCArwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoCB8IHJlZ3Jlc3NfZHVfcm9sZTEgZnJvbSBwb3N0Z3JlcyAoYWRt aW4sIGluaGVyaXQsIHNldCnCoMKgwqDCoMKgwqDCoCArwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoCB8IHJlZ3Jlc3NfZHVfcm9sZTIgZnJvbSBwb3N0Z3JlcyAoYWRtaW4s IGluaGVyaXQsIHNldCnCoHJlZ3Jlc3NfZHVfcm9sZTAgfCDCoHJlZ3Jlc3NfZHVfcm9sZTEg fCByZWdyZXNzX2R1X3JvbGUwIGZyb20gcmVncmVzc19kdV9hZG1pbiAoYWRtaW4sIGluaGVy aXQsIHNldCkrwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IHJlZ3Jlc3Nf ZHVfcm9sZTAgZnJvbSByZWdyZXNzX2R1X3JvbGUxIChpbmhlcml0KcKgwqDCoMKgwqDCoMKg wqDCoMKgwqAgK8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCByZWdyZXNz X2R1X3JvbGUwIGZyb20gcmVncmVzc19kdV9yb2xlMiAoc2V0KcKgcmVncmVzc19kdV9yb2xl MiB8IHJlZ3Jlc3NfZHVfcm9sZTAgZnJvbSByZWdyZXNzX2R1X2FkbWluIChhZG1pbinCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCArwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoCB8IHJlZ3Jlc3NfZHVfcm9sZTAgZnJvbSByZWdyZXNzX2R1X3JvbGUxIChpbmhlcml0 LCBzZXQpwqDCoMKgwqDCoMKgICvCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg IHwgcmVncmVzc19kdV9yb2xlMCBmcm9tIHJlZ3Jlc3NfZHVfcm9sZTIgKGVtcHR5KcKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgICvCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgIHwgcmVncmVzc19kdV9yb2xlMSBmcm9tIHJlZ3Jlc3NfZHVfYWRtaW4gKGFkbWluLCBz ZXQpKDUgcm93cykgIA0KPiANCj4gVGhlIHRhYnVsYXIgZm9ybSBzb2x2ZXMgdGhlIGxhdGVz dCBwYXRjaCB0cmFuc2xhdGlvbiBwcm9ibGVtcyBtZW50aW9uZWQgYnkgS3lvdGFyby4NCj4g QnV0IGl0IHJlcXVpcmVzIG1hcHBpbmcgZWxlbWVudHMgYmV0d2VlbiAzIGFycmF5LWxpa2Ug Y29sdW1ucy4NCj4gDQo+IFRvIG1vdmUgZm9yd2FyZCwgbmVlZHMgbW9yZSBvcGluaW9ucz8N Cg0KW1JNVCBIYXRdDQoNCk51ZGdpbmcgdGhpcyBhbG9uZywgYXMgaXQncyBhbiBvcGVuIGl0 ZW0uIEl0J2QgYmUgZ29vZCB0byBnZXQgdGhpcyANCnJlc29sdmVkIGJlZm9yZSBCZXRhIDEs IGJ1dCB0aGF0IG1heSBiZSB0b3VnaCBhdCB0aGlzIHBvaW50Lg0KDQpbUGVyc29uYWwgaGF0 XQ0KDQpJJ20gcHJvYmFibHkgbm90IHRoZSB0YXJnZXQgdXNlciBmb3IgdGhpcyBmZWF0dXJl LCBzbyBJJ20gbm90IHN1cmUgaG93IA0KbXVjaCB5b3Ugc2hvdWxkIHdlaWdoIG15IG9waW5p b24gKGUuZy4gSSBzdGlsbCBkb24ndCBhZ3JlZSB3aXRoIA0KZXhwbGljaXRseSBzaG93aW5n ICJlbXB0eSIsIGJ1dCBhcyBtZW50aW9uZWQsIEknbSBub3QgdGhlIHRhcmdldCB1c2VyKS4N Cg0KVGhhdCBzYWlkLCBmcm9tIGEgcmVhZGFiaWxpdHkgc3RhbmRwb2ludCwgaXQgd2FzIGVh c2llciBmb3IgbWUgdG8gZm9sbG93IA0KdGhlIHRhYnVsYXIgZm9ybSB2cy4gdGhlIHNlbnRl bmNlIGZvcm0uDQoNClRoYW5rcywNCg0KSm9uYXRoYW4NCg0K --------------xyV30OR5GTyAJinNv0QWKriz-- --------------HsLr0vKNv2USYAQ0sz0703Zb 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/x8QSccp8cZScFAmRlkKAFAwAAAAAACgkQ8QSccp8cZSdn RQ/8C+g8lavgKhAdxR6nYNjcn6cmzuGRP19QChbxJoJL47jJkaPyWO3BFqTDjE/IHoMF4l337jzT 6Lp5kCvQ0EFSiFrtlfYwJCgjiRcKTGtWe5O50omjswPWcZtd9XUAnoL9WNa7W0LLS12OUz0sMWhR xfO3pwmxMlHUUiSaWddVh5EOzWn4D697r40qDpupPs22MeQxTdAR4jlCefZeByE7R7pquDXQ8y/x H5O301ic82ckfPg6g3vhqM56WJcL9TUTYV169ooUNhNpoSgC+/VUIhH5xZc322iWqc0cgwMdWMRC xbJzPVNzoxeCn1DA8qiQI1Z+Fymy+T74g/Ra7knrNCpQXecM/R/c1/0w39dwZKjF9bg1yeby/iKW DMDmnrvpHmpgNjLMraijLLk77XtrotRBQHTTEricfr3LVe8/Jh7S3ql8Nx2l6/WtEBd01hkaF6vH f73Mx/JszeEK3Q4otAXWPdDJ+HAYQsEc89PfsmqZEHA1Fzd10eUCx39yMp2+GGwjONaUgBxm8LRq VPjVPh2nXmLcW5BoLb9mLVsFnH/Uq+C1iw/vYok7XDxmQqq0YC8xhG+GEa4Y3BWP9ZKKHJCmHPdn 5vcY21AQXLe9En6B8400zq8OOJ7aLBcEmeGWY3Cgbxpok7FhcMbFrxv24xKCEWqjMuiT+ytYbGDq 2AU= =SsWr -----END PGP SIGNATURE----- --------------HsLr0vKNv2USYAQ0sz0703Zb--