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 1ncVKQ-0002oN-Pa for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 16:49:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncVKO-0001G3-VC for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 16:49:48 +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 1ncVKO-0001Es-MF for pgsql-hackers@lists.postgresql.org; Thu, 07 Apr 2022 16:49:48 +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 1ncVKM-0000U9-A8 for pgsql-hackers@lists.postgresql.org; Thu, 07 Apr 2022 16:49:47 +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=8MTnmRWGEBzsWpDbkJ3L1MmgIeS8EQtue8UFyBbyrBI=; b=1F5shpgwIJUz2yYE2LrSUF9eal 4MyIPBwxH3cgQ6xz4GfdGvMHWp7U7welaYF557tbaJUg7kdPvtoY8AfMlQ/WVSkR8yI1IsbmyheBc Yihvrv/FXlA+JeErhqkQxpvkEEaysYsH8JbWyY/Pw3gR9ha7D9JxVw9thjZb353zo2Ki6UB+QL+8R eqImMVAL/+jJ2w7NPdor23m4nHn3ConMgrRBBzCfE9qK6SBAOn4V06Rq41PUXZQeirxuGZWqT84PS UeOPxEco8Bh0ymZWjOb4nKQruMkpBSGPIt+/YYe3+v04GpKe/qq2x/JMRhh8SRdEV35zZtCrxqM0d B8y2FEnA==; 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 1ncVKG-0007mj-10; Thu, 07 Apr 2022 16:49:41 +0000 Message-ID: <5d20f64c-fbe4-243e-690a-296a3515d679@postgresql.org> Date: Thu, 7 Apr 2022 12:49:34 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.7.0 Subject: Re: How about a psql backslash command to show GUCs? Content-Language: en-US To: Mark Dilger , Tom Lane Cc: Andrew Dunstan , David Rowley , Joe Conway , Alvaro Herrera , PostgreSQL Developers References: <202204061758.leffczewl4kd@alvherre.pgsql> <3123259.1649270440@sss.pgh.pa.us> <995e06b1-0e50-396e-fce3-934d5e511e27@dunslane.net> <3370142.1649348973@sss.pgh.pa.us> <2DB6EB50-04DF-49D1-BB5B-61C62898BB35@enterprisedb.com> <3370992.1649349445@sss.pgh.pa.us> <1F53D09A-FA14-428F-AB4E-9727D0B70DC7@enterprisedb.com> From: "Jonathan S. Katz" In-Reply-To: <1F53D09A-FA14-428F-AB4E-9727D0B70DC7@enterprisedb.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------iTAVxNvOCHmMpWZlD7YZrXXT" 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) --------------iTAVxNvOCHmMpWZlD7YZrXXT Content-Type: multipart/mixed; boundary="------------rQYKrp0uX6yhIrum4qO2e5Jw"; protected-headers="v1" From: "Jonathan S. Katz" To: Mark Dilger , Tom Lane Cc: Andrew Dunstan , David Rowley , Joe Conway , Alvaro Herrera , PostgreSQL Developers Message-ID: <5d20f64c-fbe4-243e-690a-296a3515d679@postgresql.org> Subject: Re: How about a psql backslash command to show GUCs? References: <202204061758.leffczewl4kd@alvherre.pgsql> <3123259.1649270440@sss.pgh.pa.us> <995e06b1-0e50-396e-fce3-934d5e511e27@dunslane.net> <3370142.1649348973@sss.pgh.pa.us> <2DB6EB50-04DF-49D1-BB5B-61C62898BB35@enterprisedb.com> <3370992.1649349445@sss.pgh.pa.us> <1F53D09A-FA14-428F-AB4E-9727D0B70DC7@enterprisedb.com> In-Reply-To: <1F53D09A-FA14-428F-AB4E-9727D0B70DC7@enterprisedb.com> --------------rQYKrp0uX6yhIrum4qO2e5Jw Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNC83LzIyIDEyOjQyIFBNLCBNYXJrIERpbGdlciB3cm90ZToNCj4gDQo+IA0KPj4gT24g QXByIDcsIDIwMjIsIGF0IDk6MzcgQU0sIFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4g d3JvdGU6DQo+Pg0KPj4gTWF5YmUgSSdtIGF0eXBpY2FsLCBidXQgSSdtIHByb2JhYmx5IGdv aW5nIHRvIHVzZSB0YWIgY29tcGxldGlvbg0KPj4gZWl0aGVyIHdheSwgc28gaXQncyBub3Qg cmVhbGx5IG1vcmUga2V5c3Ryb2tlcy4NCj4gDQo+IFNhbWUgaGVyZSwgYmVjYXVzZSBhZnRl ciB0YWItY29tcGxldGluZyBcZGNvblx0XHQgaW50byBcZGNvbmZpZywgSSdtIGxpa2VseSB0 byBhbHNvIHRhYi1jb21wbGV0ZSB0byBnZXQgdGhlIGxpc3Qgb2YgcGFyYW1ldGVycy4gIEkg ZnJlcXVlbnRseSBjYW4ndCByZWNhbGwgdGhlIGV4YWN0IHNwZWxsaW5nIG9mIHRoZW0uDQoN ClRoaXMgc2VlbXMgbGlrZSB0aGUgb25seSAiXGQiIGNvbW1hbmQgdGhhdCB3b3VsZCByZXF1 aXJlIHRhYiBjb21wbGV0aW9uLCANCmdpdmVuIGFsbCB0aGUgb3RoZXJzIGFyZSBmYXIgbGVz cyBkZXNjcmlwdGl2ZSAoXGR0LCBcZHYsIGV0Yy4pIEFuZCBhdCANCmxlYXN0IGZyb20gbXkg dXNlciBwZXJzcGVjdGl2ZSwgaWYgSSBldmVyIG5lZWQgYW55dGhpbmcgb3RoZXIgdGhhbiBc ZHQsIA0KSSB0eXBpY2FsbHkgaGF2ZSB0byBnbyB0byBcPyB0byBsb29rIGl0IHVwLg0KDQpJ J20gZ2VuZXJhbGx5IGluIGZhdm9yIG9mIGNvbnNpc3RlbmN5LCB0aG91Z2ggaW4gY2FzZSBz a2V3aW5nIHRvd2FyZHMgDQp3aGF0IHdlIGV4cG9zZSB0byB0aGUgdXNlci4gSWYgIlxkY29u ZmlnIiBnaXZlcyBhIGJpdCBtb3JlIGFjcm9zcyB0aGUgDQpib2FyZCwgSSdtIE9LIHdpdGgg dGhhdC4gIlxkcGFyYW0iIGNvdWxkIGJlIGEgYml0IGNvbmZ1c2luZyB0byBlbmQgdXNlcnMg DQooInBhcmFtZXRlciBmb3Igd2hhdD8iKSBzbyBJJ20gLTEgb24gdGhhdC4NCg0KSm9uYXRo YW4NCg== --------------rQYKrp0uX6yhIrum4qO2e5Jw-- --------------iTAVxNvOCHmMpWZlD7YZrXXT 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/x8QSccp8cZScFAmJPFh4FAwAAAAAACgkQ8QSccp8cZSco CRAAmWkyz3eE0faLYi3lAmjn64uIJ+F2XrGxMMjUQGJQCTzx99Rfmd/bQHxLgojMrbjEYT+IBjIQ 3NdKNqL+tRCAO1U2raKBj2QBEihY997i2HVLsrAyTLqtm2QQlA6oxyN+cYBiRSjw0R0aMU1iPiZm hq7j8+jFYLVc6llINWSMwmvaCDmYAAoYWFYTjKN73EoLThWEXxfkLmjdcoYNguolxwvYsUk3e1VN BtgzylmS3MtGeItBBLzsKfUgLJvH0r3jWZdwpfhqMgtLVO4Ff/odNz4mvuo3uSuMexyjKpWJTJSb CGFhSoNpp/Ksb+Kk8wDUmHZUdVLLNlSrjat6pk8y7tzCILHuV0DadAZa1S/yGXGmr43hTsP3HxFg yv4guQw37O81IW3RE93McBlbwKCpgy2GQEejzAqXew/UQvnG2hlFsjYbZ/Hz+/WMn28/g8SsJSMl 1jDn06z/JgYabJDZ/s8XeLK3Ldphb4HW+VWcdeOZGPBTzSp35xoUVHlRZVPwZgEaLoymqZ9XE8vP R+xYICGYNtEuHjOZINnNQx8zfDl3yrfw8iMtcTGsv3xuT4JfYZp9FkGE2NU0yUDYCLa/unj7AvMZ 58n0YyihclCU83oPgggFY+EZPFR6It8q9asXX6vaZwO1T59Q3U0WzQbY5cGKZENjocrUl2TB0dUi ++Q= =673D -----END PGP SIGNATURE----- --------------iTAVxNvOCHmMpWZlD7YZrXXT--