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 1ncGky-0006TT-QB for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 01:16:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ncGkx-0001EG-9Q for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Apr 2022 01:16:15 +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 1ncGkx-0001E4-0K for pgsql-hackers@lists.postgresql.org; Thu, 07 Apr 2022 01:16:15 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ncGku-00018o-Nw; Thu, 07 Apr 2022 01:16:13 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2371G5nd3201871; Wed, 6 Apr 2022 21:16:05 -0400 From: Tom Lane To: "Jonathan S. Katz" cc: Joe Conway , Alvaro Herrera , pgsql-hackers@lists.postgresql.org, Mark Dilger Subject: Re: How about a psql backslash command to show GUCs? In-reply-to: <38891fd8-dceb-c956-ec5c-61c1a3e9486d@postgresql.org> References: <202204061758.leffczewl4kd@alvherre.pgsql> <3123259.1649270440@sss.pgh.pa.us> <38891fd8-dceb-c956-ec5c-61c1a3e9486d@postgresql.org> Comments: In-reply-to "Jonathan S. Katz" message dated "Wed, 06 Apr 2022 17:34:36 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3201869.1649294165.1@sss.pgh.pa.us> Date: Wed, 06 Apr 2022 21:16:05 -0400 Message-ID: <3201870.1649294165@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Jonathan S. Katz" writes: > I am a bit torn between "\dcp" (or \dsetting / \dconfig? we don't > necessarily need for it to be super short) and "\sc". Certainly with > pattern matching the interface for the "\d" commands would fit that > pattern. "\sc" would make sense for a thorough introspection of what is > in the GUC. That said, we get that with SHOW today. > So I'm leaning towards something in the "\d" family. I agree that \d-something makes the most sense from a functionality standpoint. But I don't want to make the name too long, even if we do have tab completion to help. \dconf maybe? regards, tom lane