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 1ncV3y-0001iK-Hx for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 16:32: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 1ncV3w-0008Cx-M7 for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 16:32:48 +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 1ncV10-00031A-V6 for pgsql-hackers@lists.postgresql.org; Thu, 07 Apr 2022 16:29:46 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncV0z-0003LV-0t for pgsql-hackers@lists.postgresql.org; Thu, 07 Apr 2022 16:29:46 +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=lOYsciceuuZUdHDGkcV3QtzIvxSNbLh7+65cMrQdrS0=; b=q9cPkIjzfJxoRbhbjS71psmwHE chorugEp5HDoxGgd7ZKXRA8G8yPv/HaDFpzvNLiNpgsoAtQm/bXxV07jLV6W3UHbluq0z/YHTeCZg kxgsmfBNQDNRjq7uYtdSXKZz/dEaGlXy3NHRpsKpamqndLn+0VKLwTpE8h/KkjbIplrJjc5eulMHP /4/QfOnWuVi27TXYL5sGi6iKbjYFRgfBJYNVw8bdq6ct5lUqVjkwzgYGvHK1wLWomuJ7B27h0OluE UHmLzDhovB9TtrTfCjo0+A2lBBKVizgFGlR5mbaxVTD8I/uUBo/8DNAjyUY447ulBPTRtn2/6MNN/ R5cv77yQ==; 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 1ncV0u-0007PV-RF; Thu, 07 Apr 2022 16:29:42 +0000 Message-ID: Date: Thu, 7 Apr 2022 12:29:35 -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: Tom Lane , Justin Pryzby Cc: "David G. Johnston" , Joe Conway , Alvaro Herrera , pgsql-hackers@lists.postgresql.org, Pavel Luzanov , Greg Stark , Mark Dilger References: <202204061758.leffczewl4kd@alvherre.pgsql> <3123259.1649270440@sss.pgh.pa.us> <38891fd8-dceb-c956-ec5c-61c1a3e9486d@postgresql.org> <3201870.1649294165@sss.pgh.pa.us> <6693b128-b9e5-fd5e-e8d2-b331dac52cb8@postgresql.org> <3221981.1649300574@sss.pgh.pa.us> <20220407152449.GD24419@telsasoft.com> <3369130.1649348542@sss.pgh.pa.us> From: "Jonathan S. Katz" In-Reply-To: <3369130.1649348542@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------IICSabJ9ABp8HpnqRXgmPhRX" 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) --------------IICSabJ9ABp8HpnqRXgmPhRX Content-Type: multipart/mixed; boundary="------------N2YVnsFd0fa3jDq73SSF4vUb"; protected-headers="v1" From: "Jonathan S. Katz" To: Tom Lane , Justin Pryzby Cc: "David G. Johnston" , Joe Conway , Alvaro Herrera , pgsql-hackers@lists.postgresql.org, Pavel Luzanov , Greg Stark , Mark Dilger Message-ID: Subject: Re: How about a psql backslash command to show GUCs? References: <202204061758.leffczewl4kd@alvherre.pgsql> <3123259.1649270440@sss.pgh.pa.us> <38891fd8-dceb-c956-ec5c-61c1a3e9486d@postgresql.org> <3201870.1649294165@sss.pgh.pa.us> <6693b128-b9e5-fd5e-e8d2-b331dac52cb8@postgresql.org> <3221981.1649300574@sss.pgh.pa.us> <20220407152449.GD24419@telsasoft.com> <3369130.1649348542@sss.pgh.pa.us> In-Reply-To: <3369130.1649348542@sss.pgh.pa.us> --------------N2YVnsFd0fa3jDq73SSF4vUb Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNC83LzIyIDEyOjIyIFBNLCBUb20gTGFuZSB3cm90ZToNCj4gSnVzdGluIFByeXpieSA8 cHJ5emJ5QHRlbHNhc29mdC5jb20+IHdyaXRlczoNCj4+IFNIT1cgYW5kIGN1cnJlbnRfc2V0 dGluZygpIHRyYW5zbGF0ZSB0byBodW1hbiB1bml0cywgd2hpY2ggaXMgcGFydGljdWxhcmx5 DQo+PiB1c2VmdWwgZm9yIHNvbWUgc2V0dGluZ3MsIGxpa2UgdGhvc2Ugd2l0aCB1bml0cyBv ZiA4ayBwYWdlcy4NCj4+IElzIGl0IGJldHRlciB0byB1c2UgdGhhdCAiY29va2VkIiB2ZXJz aW9uIGZvciBkaXNwbGF5IGluIHRoZSBiYWNrc2xhc2ggY29tbWFuZA0KPj4gaW5zdGVhZCBv ZiB0aGUgcmF3IHZpZXcgZnJvbSBwZ19zZXR0aW5ncyA/DQo+IA0KPiBPaCwgdGhhdCdzIGEg Z29vZCBpZGVhIC0tLSBsZXRzIHVzIGRyb3AgdGhlIHVuaXRzIGNvbHVtbiBlbnRpcmVseS4N Cg0KKzENCg0KPiBUaGUgYXR0YWNoZWQgcmV2aXNpb24gZG9lcyB0aGF0IGFuZCBtb3ZlcyB0 aGUgInR5cGUiIGNvbHVtbiB0bw0KPiBzZWNvbmRhcnkgc3RhdHVzLCBhcyBkaXNjdXNzZWQg dXB0aHJlYWQuICBJIGFsc28gYWRkZWQgZG9jcyBhbmQNCj4gc2ltcGxlIHJlZ3Jlc3Npb24g dGVzdHMsIGFuZCBmaXhlZCB0d28gcHJvYmxlbXMgdGhhdCB3ZXJlIHByZXZlbnRpbmcNCj4g Y29tcGxldGlvbiBvZiBjdXN0b20gKHF1YWxpZmllZCkgR1VDIG5hbWVzICh3ZSBuZWVkIHRv IHVzZSB0aGUNCj4gVkVSQkFUSU0gb3B0aW9uIGZvciB0aG9zZSBxdWVyaWVzKS4gIFRoZXJl IHJlbWFpbnMgdGhlIGlzc3VlIHRoYXQNCj4gdGFiIGNvbXBsZXRpb24gZm9yIEdVQyBuYW1l cyBvdWdodCB0byBiZSBjYXNlLWluc2Vuc2l0aXZlLCBidXQNCj4gdGhhdCdzIGEgcHJlLWV4 aXN0aW5nIGJ1ZyBpbiB0YWItY29tcGxldGUuYydzIG90aGVyIEdVQyBuYW1lDQo+IGNvbXBs ZXRpb25zIHRvbzsgSSdsbCB0YWNrbGUgaXQgbGF0ZXIuDQo+IA0KPiBBcyBmb3IgdGhlIG5h bWUsIFxkY29uZiBoYXMgYSBzbGlnaHQgcGx1cmFsaXR5IGluIHZvdGVzIHNvIGZhciwNCj4g c28gSSdtIHN0aWNraW5nIHdpdGggdGhhdC4NCj4gDQo+IEkgdGhpbmsgdGhpcyBpcyByZWFk eSB0byBnbyB1bmxlc3Mgc29tZW9uZSBoYXMgYSBzaWduaWZpY2FudGx5DQo+IGJldHRlciBp ZGVhLg0KDQpJIHJhbiB0aGUgZXF1aXZhbGVudCBTUUwgbG9jYWxseSBhbmQgaXQgTEdUTS4g RG9jcyByZWFkIHdlbGwgdG8gbWUuIENvZGUgDQpsb29rcyBhcyBnb29kIGFzIGl0IGNhbiB0 byBtZS4NCg0KKzENCg0KSm9uYXRoYW4NCg== --------------N2YVnsFd0fa3jDq73SSF4vUb-- --------------IICSabJ9ABp8HpnqRXgmPhRX 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/x8QSccp8cZScFAmJPEW8FAwAAAAAACgkQ8QSccp8cZSdw fBAAmWMyKKtEhuKM7FtFL5NSKepqn7XNQW3i6pNlQBbA96EOvecBsLlzWzwLmgL6L7JBYKjQE2XG EyeAjAYflW1VqDhj834i3iD9T/EJd9bFXuoxU0H6kJS27pedSHPcF/VomxX8P9a1RQgettQMDWqp 3h37YVln86VbonY8N4pVuTP3+laHrmCLy+2mbKDxyX28uDj0Zw6RL+Trjj1yf6EQjKS0Bvi7OvQP vYcqiKA9mRdxf+edlx0pQJi3OYQ0wf6yIA4V26Zoa+kjE8tpYq7PtLvz66Tys7nA/4g44h2jOGtN Fgi1kvbNdIbY/9KwptO9+Nhr49jzObuJACoeJO5Hs1s7EzGuYl/KsTvXQLvH5myuUE/c9n2YGngw NkorMP0pD1cqI2oe88AYkrWC9DyrJNXs/6s8EJPGthD9i9MIPu6871ZRADeNbHrU0TjGQ0vBL9VE vXhiOSTULNkX9/aAxSWfD8HwB/FK/TE76fuL4OxXXnkZ86NCUw/EJq4zYDzr98BYaSo5yGmmmBjO W9vMWZAmAecQGNGrjuCHkc5IXKJdi6Zk05xJrdYCneR62fbrIRs7S6tkDJDPc7ZpaXfc/3CL2dLq TWWs0H5X8E0LSQ5TTTqK5ddpN8/IGE1px2VnlkJuooI9OdLiOesE7WatxMhWaoj2/jwNMlUxDcwU S8Q= =2jQ1 -----END PGP SIGNATURE----- --------------IICSabJ9ABp8HpnqRXgmPhRX--