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 1neMO3-00047g-D2 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Apr 2022 19:41:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1neMO0-0002Mj-JR for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Apr 2022 19:41:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1neMNz-0002Ma-OA for pgsql-hackers@lists.postgresql.org; Tue, 12 Apr 2022 19:41:12 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1neMNs-0008Mn-Ub for pgsql-hackers@lists.postgresql.org; Tue, 12 Apr 2022 19:41:10 +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=81kTuZqUmyGTIUMQ1ejeLSAvebVFk+OaFb98VDOinNU=; b=KJikLAzETdkkBzmwtxB87uJchH hUgE7LixwlPupLCHVB0Nj94Shxhb3UBek8kg+ykwyBFrNqVPLb2VIfUyRl4b3f3WtmeEYDVSaqiur rv7R/Mm+Lz1Zv5JVtDjMUIjl8TGQql+tTWp9QnkgDLbzz7Vf8N/AxOyRSApIoIhLJxL2TVVAWy0qD +A1QplFe9+LpztrGumnm2AiO+ieume9BQ32ucvLWUUPDDjI68/tmnLflVtsZhW8Go4WOVLjFJtnhr 0NaLRGhOdBmqefPiizWrVRgCW9wmCIVJIwwISotYfJ1ve5SVS2YTYNDDLY6oZgWml/GVRASZ8F0jJ zoi5l+bg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1neMNi-0007kY-UO; Tue, 12 Apr 2022 19:40:56 +0000 Message-ID: Date: Tue, 12 Apr 2022 15:40:49 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.8.0 Subject: Re: How about a psql backslash command to show GUCs? Content-Language: en-US To: Tom Lane Cc: Julien Rouhaud , Christoph Berg , Pavel Stehule , "David G. Johnston" , Joe Conway , Mark Dilger , Andrew Dunstan , David Rowley , Alvaro Herrera , PostgreSQL Developers References: <3370142.1649348973@sss.pgh.pa.us> <2DB6EB50-04DF-49D1-BB5B-61C62898BB35@enterprisedb.com> <3370992.1649349445@sss.pgh.pa.us> <711e43b9-6499-6a8b-0802-fb549874658e@joeconway.com> <3400691.1649363759@sss.pgh.pa.us> <4105551.1649514677@sss.pgh.pa.us> <4115803.1649521632@sss.pgh.pa.us> <043bcb40-052f-5c85-63ff-d6a2b5a0b7ca@postgresql.org> <495595.1649704355@sss.pgh.pa.us> <9439380b-a81f-c910-f527-db4d470b026b@postgresql.org> <531275.1649707882@sss.pgh.pa.us> <7bba5a32-65fe-04e1-7c36-efd963a625c9@postgresql.org> <807242.1649776780@sss.pgh.pa.us> <816940.1649782841@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: <816940.1649782841@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------9ph7CKqEBTq5xn0IBWaq4Vge" 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) --------------9ph7CKqEBTq5xn0IBWaq4Vge Content-Type: multipart/mixed; boundary="------------XncqcX00PA21K0z2rdI6gUHH"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane Cc: Julien Rouhaud , Christoph Berg , Pavel Stehule , "David G. Johnston" , Joe Conway , Mark Dilger , Andrew Dunstan , David Rowley , Alvaro Herrera , PostgreSQL Developers Message-ID: Subject: Re: How about a psql backslash command to show GUCs? References: <3370142.1649348973@sss.pgh.pa.us> <2DB6EB50-04DF-49D1-BB5B-61C62898BB35@enterprisedb.com> <3370992.1649349445@sss.pgh.pa.us> <711e43b9-6499-6a8b-0802-fb549874658e@joeconway.com> <3400691.1649363759@sss.pgh.pa.us> <4105551.1649514677@sss.pgh.pa.us> <4115803.1649521632@sss.pgh.pa.us> <043bcb40-052f-5c85-63ff-d6a2b5a0b7ca@postgresql.org> <495595.1649704355@sss.pgh.pa.us> <9439380b-a81f-c910-f527-db4d470b026b@postgresql.org> <531275.1649707882@sss.pgh.pa.us> <7bba5a32-65fe-04e1-7c36-efd963a625c9@postgresql.org> <807242.1649776780@sss.pgh.pa.us> <816940.1649782841@sss.pgh.pa.us> In-Reply-To: <816940.1649782841@sss.pgh.pa.us> --------------XncqcX00PA21K0z2rdI6gUHH Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNC8xMi8yMiAxOjAwIFBNLCBUb20gTGFuZSB3cm90ZToNCj4gIkpvbmF0aGFuIFMuIEth dHoiIDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz4gd3JpdGVzOg0KPj4gT24gNC8xMi8yMiAxMTox OSBBTSwgVG9tIExhbmUgd3JvdGU6DQo+Pj4gSXQnZCBqdXN0IGxvb2sgbGlrZSB0aGlzLCBJ IHRoaW5rLiAgSSBzZWUgZnJvbSBsb29raW5nIGF0IGd1Yy5jIHRoYXQNCj4+PiBib290X3Zh bCBjYW4gYmUgTlVMTCwgc28gd2UnZCBiZXR0ZXIgdXNlIElTIERJU1RJTkNUIEZST00uDQo+ IA0KPj4gSSB0ZXN0ZWQgaXQgYW5kIEkgbGlrZSB0aGlzIGEgbG90IGJldHRlciwgYXQgbGVh c3QgaXQncyBtdWNoIG1vcmUNCj4+IGNvbnNvbGlkYXRlZC4gVGhleSBhbGwgc2VlbSB0byBi ZSBnZW5lcmF0ZWQgKGRpcmVjdG9yaWVzLCB0aW1lem9uZXMsDQo+PiBjb2xsYXRpb25zL2Vu Y29kaW5ncykuDQo+IA0KPiBZZWFoLCBtb3N0IG9mIHdoYXQgc2hvd3MgdXAgaW4gYSBtaW5p bWFsbHktY29uZmlndXJlZCBpbnN0YWxsYXRpb24gaXMNCj4gcG9zdG1hc3Rlci1jb21wdXRl ZCBzZXR0aW5ncyBsaWtlIGNvbmZpZ19maWxlLCByYXRoZXIgdGhhbiB0aGluZ3MNCj4gdGhh dCB3ZXJlIGFjdHVhbGx5IHNldCBieSB0aGUgREJBLiAgUGVyc29uYWxseSBJJ2QgcmF0aGVy IGhpZGUgdGhlDQo+IG9uZXMgdGhhdCBoYXZlIHNvdXJjZSA9ICdvdmVycmlkZScsIGJ1dCB0 aGF0IGRpZG4ndCBzZWVtIHRvIGJlIHRoZQ0KPiBjb25zZW5zdXMuDQoNClRoZSBsaXN0IHNl ZW1zIG1vcmUgcmVhc29uYWJsZSBub3csIHRob3VnaCBub3cgdGhhdCBJJ20gZnVsbHkgaW4g dGhlIA0KImxlc3MgaXMgbW9yZSIgY2FtcCBiYXNlZCBvbiB0aGUgIm5vbi1kZWZhdWx0cyIg ZGVzY3JpcHRpb24sIEkgdGhpbmsgDQphbnl0aGluZyB3ZSBjYW4gZG8gdG8gZnVydGhlciBw cnVuZSBpcyBnb29kLg0KDQo+PiBUaGUgb25lIGV4Y2VwdGlvbiB0byB0aGlzIHNlZW1zIHRv IGJlICJtYXhfc3RhY2tfZGVwdGgiLCB3aGljaCBpcw0KPj4gcmVuZGVyaW5nIG9uIG15ICJc ZGNvbmZpZyIgdGhvdWdoIEkgZGlkbid0IGNoYW5nZSBpdCwgYW4gaXQncyBzaG93aW5nDQo+ PiBpdCdzIGRlZmF1bHQgdmFsdWUgb2YgMk1CLiAiYm9vdF92YWwiIHNheXMgMTAwLCAicmVz ZXRfdmFsIiBzYXlzIDIwNDgsDQo+PiBhbmQgaXQncyBjb21tZW50ZWQgb3V0IGluIG15IHBv c3RncmVzcWwuY29uZi4gRG8gd2Ugd2FudCB0byBhbGlnbiB0aGF0Pw0KPiANCj4gSSBkb24n dCB0aGluayB0aGVyZSdzIGFueSBwcmluY2lwbGVkIHRoaW5nIHdlIGNvdWxkIGRvIGFib3V0 IHRoYXQgaW4NCj4gcHNxbC4gIFRoZSBib290X3ZhbCBpcyBhIGNvbnNlcnZhdGl2ZWx5IHNt YWxsIDEwMGtCLCBidXQgd2UgY3JhbmsNCj4gdGhhdCB1cCBhdXRvbWF0aWNhbGx5IGJhc2Vk IG9uIGdldHJsaW1pdChSTElNSVRfU1RBQ0spLCBzbyBvbiBhbnkNCj4gcmVhc29uYWJsZSBw bGF0Zm9ybSBpdCdzIGdvaW5nIHRvIHNob3cgYXMgbm90IGJlaW5nIGRlZmF1bHQuDQoNCkdv dCBpdC4NCg0KV2UgbWF5IGJlIGF0IGEgcG9pbnQgd2hlcmUgaXQncyAiZ29vZCBlbm91Z2gi IGFuZCBsZXQgbW9yZSBwZW9wbGUgY2hpbWUgDQppbiBkdXJpbmcgYmV0YS4NCg0KVGhhbmtz LA0KDQpKb25hdGhhbg0K --------------XncqcX00PA21K0z2rdI6gUHH-- --------------9ph7CKqEBTq5xn0IBWaq4Vge 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/x8QSccp8cZScFAmJV1cEFAwAAAAAACgkQ8QSccp8cZSfw JxAAtnbxMVspAimjXb++//3DCR54301vl/h9PoWFZb8yF09tX3pyB+7mINio+hIqALTyQrVb8atN 8/WbFXzDmHurPrSdpLtGt9sb9Klvvczta2wyVdcswoSWgHeceglDpa2JxvtSVE/ei1b+pASSDd3o Yqxo5MVi6WdLJ5qXr8E/zluyeOfAUyiU1EbPROdl2dysHhGcc31q/OI6NgHZsITTB3Zqujh2Q7va nZXHwpA1Mx3SpVviaHBYcECgNkwlhONClPqXXc+kI7i6t6JAgmKJmC6uTkadcK653xMenoMWaun+ 8/kg8oQpOnUZiHa0FcgDXPvIfpON39uKlwmHjCv9sjvckJkI0W9rDtHKvyhkPnPAUmx/3xjefhJY fdm+DI1SNt4HOnvP+rjY4nUKLbX6y+4KxDU5XhCyA6RDLqUqFzxkzQVh5s5GwoF1q6w7BqniJz46 4uhQeYUiHvGGcV1z8CIIJiZjwYJvnWvfC0upxVnqr1139SObScAOq9931eB1PHyrcgKzW/Xei5UB LHfcC0oB8tNonR+m2H9xmydyVuyMTninfY5vGbMILRnrxD2kY+CuRE/E2pIeJrlifXl3qkYE53wB TB7NSfo1y8ey6KmygMUA8W3jPMvfBWdoR3MRTIvUHaGgQs+B3/l89uUIHk5ZG/j192w+0Wlcvtfl jUo= =Z20P -----END PGP SIGNATURE----- --------------9ph7CKqEBTq5xn0IBWaq4Vge--