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 1qCoBc-0004Pt-FF for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jun 2023 21:19:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCoBa-000064-Px for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Jun 2023 21:19:18 +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 1qCoBa-00005T-F6; Fri, 23 Jun 2023 21:19:18 +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 1qCoBU-0005dd-6G; Fri, 23 Jun 2023 21:19:17 +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=sT36/m0tS00LoMrSJJspIex8sXWU/IpwHLSwmGyPY34=; b=ekEZwiWsrserNW+mzua+8lI3UK tZWatN4ggXWCc/B+1uk/VZ8BHlBSx45OAKatODeS9oUDPSIYORcE3jenR2WCxAHAXpAvvd5m8Lh39 OQQUmhuow/TxRd8GO/3wlTUUbWd3L7WNLydtIBPT12hIl7lOEDGz1zuTHCiEm4wObGxuh/+7waqgx 4/D/H5ppgM7FcTwpGv6odTImxhiGDnfLd0UbQC1+jpduj0kjCgUO5HoFsabdZMskmCbJT2PinxPXM ufRaGjYeZIn8ejPguqnG4c564cPNi5i8acU5YLbri93njHPVpIt5ugSGWSCZY+mFVQEOO05RO4msy C3bhIuqg==; 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 1qCoBL-000I7Q-7L; Fri, 23 Jun 2023 21:19:08 +0000 Message-ID: Date: Fri, 23 Jun 2023 17:18:59 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: psql: Add role's membership options to the \du+ command Content-Language: en-US To: "David G. Johnston" , Tom Lane Cc: Pavel Luzanov , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org, horikyota.ntt@gmail.com References: <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> <6b64c59a-fe41-bb07-d0cd-856896412b00@postgresql.org> <7aa3d663-1ea9-de0d-c13a-cbce83902214@postgrespro.ru> <2aa2bbb9-d8cb-cddf-875f-49b2634525c1@postgresql.org> <4128935.1687478926@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------ieC0mkdiPnDXaGJT0ef33Usa" 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) --------------ieC0mkdiPnDXaGJT0ef33Usa Content-Type: multipart/mixed; boundary="------------f9GIpiwPuaC90WmaFqThS2sD"; protected-headers="v1" From: "Jonathan S. Katz" To: "David G. Johnston" , Tom Lane Cc: Pavel Luzanov , Robert Haas , David Zhang , "pgsql-hackers@lists.postgresql.org" , rmt@lists.postgresql.org, horikyota.ntt@gmail.com Message-ID: Subject: Re: psql: Add role's membership options to the \du+ command References: <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> <6b64c59a-fe41-bb07-d0cd-856896412b00@postgresql.org> <7aa3d663-1ea9-de0d-c13a-cbce83902214@postgrespro.ru> <2aa2bbb9-d8cb-cddf-875f-49b2634525c1@postgresql.org> <4128935.1687478926@sss.pgh.pa.us> In-Reply-To: --------------f9GIpiwPuaC90WmaFqThS2sD Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNi8yMy8yMyAxMTo1MiBBTSwgRGF2aWQgRy4gSm9obnN0b24gd3JvdGU6DQo+IE9uIFRo dSwgSnVuIDIyLCAyMDIzIGF0IDU6MDjigK9QTSBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEu dXMgDQo+IDxtYWlsdG86dGdsQHNzcy5wZ2gucGEudXM+PiB3cm90ZToNCj4gDQo+ICAgICAi Sm9uYXRoYW4gUy4gS2F0eiIgPGprYXR6QHBvc3RncmVzcWwub3JnDQo+ICAgICA8bWFpbHRv OmprYXR6QHBvc3RncmVzcWwub3JnPj4gd3JpdGVzOg0KPiAgICAgID4gT24gNi8xNS8yMyAy OjQ3IFBNLCBEYXZpZCBHLiBKb2huc3RvbiB3cm90ZToNCj4gICAgICA+PiBSb2JlcnQgLSBj YW4geW91IHBsZWFzZSBjb21tZW50IG9uIHdoYXQgeW91IGFyZSB3aWxsaW5nIHRvDQo+ICAg ICBjb21taXQgaW4NCj4gICAgICA+PiBvcmRlciB0byBjbG9zZSBvdXQgeW91ciBvcGVuIGl0 ZW0gaGVyZS7CoCBNeSB0YWtlIGlzIHRoYXQgdGhlDQo+ICAgICBkZXNpZ24gZm9yDQo+ICAg ICAgPj4gdGhpcywgdGhlIHRhYnVsYXIgZm9ybSBhIGNvdXBsZSBvZiBlbWFpbHMgYWdvIChj b3BpZWQgaGVyZSksIGlzDQo+ICAgICAgPj4gcmVhZHktdG8tY29tbWl0LCBqdXN0IG5lZWRp bmcgdGhlIGFjdHVhbCAodHJpdmlhbCkgY29kZSBjaGFuZ2VzDQo+ICAgICB0byBiZQ0KPiAg ICAgID4+IG1hZGUgdG8gYWNjb21wbGlzaCBpdC4NCj4gDQo+ICAgICAgPiBDYW4gd2UgcmVz b2x2ZSB0aGlzIGJlZm9yZSBCZXRhIDI/WzFdIFRoZSBSTVQgb3JpZ2luYWxseSBhZHZpc2Vk DQo+ICAgICB0byB0cnkNCj4gICAgICA+IHRvIHJlc29sdmUgYmVmb3JlIEJldGEgMVsyXSwg YW5kIHRoaXMgc2VlbXMgdG8gYmUgbGluZ2VyaW5nLg0KPiANCj4gICAgIEF0IHRoaXMgcG9p bnQgSSBraW5kYSBkb3VidCB0aGF0IHdlIGNhbiBnZXQgdGhpcyBkb25lIGJlZm9yZSBiZXRh Mg0KPiAgICAgZWl0aGVyLCBidXQgSSdsbCBwdXQgaW4gbXkgdHdvIGNlbnRzIGFueXdheToN Cg0KW1JNVCBIYXRdDQoNCldlbGwsIHRoZSBwcm9iYWJpbGl0eSBvZiBjb21wbGV0aW5nIHRo aXMgYmVmb3JlIHRoZSBiZXRhIDIgZnJlZXplIGlzIA0KZWZmZWN0aXZlbHkgemVybyBub3cu IFRoaXMgaXMgYSBiaXQgZGlzYXBwb2ludGluZyBhcyB0aGVyZSB3YXMgYW1wbGUgDQp0aW1l IHNpbmNlIHRoZSBmaXJzdCBSTVQgbnVkZ2Ugb24gdGhlIGlzc3VlLiBCdXQgbGV0J3MgbW92 ZSBmb3J3YXJkIGFuZCANCnJlc29sdmUgaXQgYmVmb3JlIEJldGEgMy4NCg0KPiAgICAgKiBJ IGFncmVlIHRoYXQgdGhlICJ0YWJ1bGFyIiBmb3JtYXQgbG9va3MgbmljZXIgYW5kIGhhcyBm ZXdlciBpMThuDQo+ICAgICBpc3N1ZXMgdGhhbiB0aGUgb3RoZXIgcHJvcG9zYWxzLg0KPiAN Cj4gQXMgeW91IGFyZSBvbiBib2FyZCB3aXRoIGEgc2VwYXJhdGUgY29tbWFuZCBwbGVhc2Ug Y2xhcmlmeSB3aGV0aGVyIHlvdSANCj4gbWVhbiB0aGUgdGFidWxhciBmb3JtYXQgYnV0IHN0 aWxsIHdpdGggbmV3bGluZXMsIG9uZSByb3cgcGVyIGdyYW50ZWUsIG9yIA0KPiB0aGUgdGFi bGUgd2l0aCBvbmUgcm93IHBlciBncmFudG9yLWdyYW50ZWUgcGFpci4NCj4gDQo+IEkgc3Rp bGwgbGlrZSB1c2luZyBuZXdsaW5lcyBoZXJlIGV2ZW4gaW4gdGhlIHNlcGFyYXRlIG1ldGEt Y29tbWFuZC4NCg0KKEknbGwgc2F2ZSBmb3IgdGhlIGRvd250aHJlYWQgY29tbWVudCkuDQoN Cj4gDQo+ICAgICAqIFBlcnNvbmFsbHkgSSBjb3VsZCBkbyB3aXRob3V0IHRoZSAiZW1wdHki IGJ1c2luZXNzLCBidXQgdGhhdCBzZWVtcw0KPiAgICAgdW5uZWNlc3NhcnkgaW4gdGhlIHRh YnVsYXIgZm9ybWF0OyBhbiBlbXB0eSBjb2x1bW4gd2lsbCBzZXJ2ZSBmaW5lLg0KPiANCj4g DQo+IEkgZGlzYWdyZWUsIGJ1dCBub3Qgc3Ryb25nbHkuDQo+IA0KPiBJIGtpbmRhIGV4cGVj dGVkIHlvdSB0byBiZSBvbiB0aGUgc2lkZSBvZiAid2h5IGFyZSB3ZSBkaXNjdXNzaW5nIGEg DQo+IHNpdHVhdGlvbiB0aGF0IHNob3VsZCBqdXN0IGJlIHByb2hpYml0ZWQiIHRob3VnaC4N Cg0KW1BlcnNvbmFsIGhhdF0NCg0KSSdtIHN0aWxsIG5vdCBhIGZhbiBvZiAiZW1wdHkiIGJ1 dCBwZXJoYXBzIHRoZSBmb3JtYXR0aW5nIGFyb3VuZCB0aGUgDQoic2VwYXJhdGUgY29tbWFu ZCIgd2lsbCBoZWxwIGRyaXZlIGEgY29uY2x1c2lvbiBvbiB0aGlzLg0KDQo+IA0KPiAgICAg KiBJIGFsc28gYWdyZWUgd2l0aCBQYXZlbCdzIGNvbW1lbnQgdGhhdCB3ZSdkIGJlIGJldHRl ciBvZmYgdGFraW5nDQo+ICAgICB0aGlzIG91dCBvZiBcZHUgYWx0b2dldGhlciBhbmQgaW52 ZW50aW5nIGEgc2VwYXJhdGUgXGQgY29tbWFuZC4NCj4gICAgIE1heWJlICJcZHJnIiBmb3Ig ImRpc3BsYXkgcm9sZSBncmFudHMiPw0KPiANCj4gSnVzdCB0byBiZSBjbGVhciwgdGhlIG9w ZW4gaXRlbSBmaXggcHJvcG9zYWwgaXMgdG8gcmVtb3ZlIHRoZSBwcmVzZW50bHkgDQo+IGJy b2tlbiAoZHVlIHRvIGl0IHNob3dpbmcgZHVwbGljYXRlcyB3aXRob3V0IGFueSBjb250ZXh0 KSAibWVtYmVyIG9mIiANCj4gYXJyYXkgaW4gXGR1IGFuZCBtYWtlIGEgc2ltcGxlIHRhYmxl IHJlcG9ydCBvdXRwdXQgaW4gXGRyZyBpbnN0ZWFkLg0KPiANCj4gSSdtIGdvb2Qgd2l0aCBc ZHJnIGFzIGEgbmV3IG1ldGEtY29tbWFuZC4NCg0KW1BlcnNvbmFsIGhhdF0NCg0KKzEgZm9y IGEgbmV3IGNvbW1hbmQuIFRoZSBwcm9wb3NhbCBhYm92ZSBzZWVtcyByZWFzb25hYmxlLg0K DQpUaGFua3MsDQoNCkpvbmF0aGFuDQo= --------------f9GIpiwPuaC90WmaFqThS2sD-- --------------ieC0mkdiPnDXaGJT0ef33Usa 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/x8QSccp8cZScFAmSWDEMFAwAAAAAACgkQ8QSccp8cZSf/ nQ/9Fh/q7pXQ2eMfzJohIGS4wze6GjxIxMDlrbjgdZTcO8my+du0qYqsBZiV3lk0Jzn9n46h/sWb hqry5rHyCyFwbNzuS+FFmgfDt0sQ7491Fa+5LiCmwTs9V+vfCDCX0RWhloUISLOAwPvQ9MFmYEwa I6+9g6WPVQsoOoFibAeNZg5fmcqauQeYBTMXjWJPspJ8JjgQwsS+1+uSlF1HHtHvRPFZ3DTqaSBl 3zX7LLhpepaQF8XO3piDRRTGqkso6cLve/vP5/NVZV3mGbgtzgPHEHRIUMMa0xXz5vSrIhPOWf3j TnIp6dACytBNV9ycJpEvtz79PhZi3cwn3Fvzblvcgbn/YlmAlhrHnCycJJLE8LmiwLoZXrILzNXA TWycvMsEuJihl72A6O4YFLdFoU4EMhFS18XYnGpJdnl8TisRwf/KEprPLpHjthQ1S/La5BgzsA0W xDWCM2kPrk+veDgKHEncbdiYEFl9Wvq17hUOmaPWk4oyKDJBjrYX4dHcS4TsuTGay4NxJOlqCIxr xEFD3ZuSyF0TwvnQ6yQqueCCfZRiwdCmCIbgj7GvxyQ+3eX23owRTQpNEe+bv7OWNtbKFxFsy1Cr 3KHx1j5RZ2o5nDNgLCOu+3QD+vJuvijeMNjt9ByJCZOwMfAovw26bBSmgSSezw/Y7DzU6f4G4u8O leY= =3tYX -----END PGP SIGNATURE----- --------------ieC0mkdiPnDXaGJT0ef33Usa--