Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYDfL-00068Z-0x for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 15:14:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYDfK-0006MV-Hy for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 15:14:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYDfJ-0006Ll-7m for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 15:14:45 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYDfG-0003d5-90 for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 15:14:44 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v0UFEaae024327; Mon, 30 Jan 2017 10:14:36 -0500 From: Tom Lane To: Stephen Frost cc: Pavel Stehule , Christoph Berg , Daniel Verite , PostgreSQL Hackers Subject: Re: One-shot expanded output in psql using \G In-reply-to: <20170130150458.GC9812@tamriel.snowman.net> References: <20170127132737.6skslelaf4txs6iw@msg.credativ.de> <74e7fd23-f5a9-488d-a8c4-1e0da674b27c@manitou-mail.org> <20170130101424.fo4knpn4blaohazk@msg.df7cb.de> <20170130134608.GA9812@tamriel.snowman.net> <20170130150458.GC9812@tamriel.snowman.net> Comments: In-reply-to Stephen Frost message dated "Mon, 30 Jan 2017 10:04:59 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <24325.1485789276.1@sss.pgh.pa.us> Date: Mon, 30 Jan 2017 10:14:36 -0500 Message-ID: <24326.1485789276@sss.pgh.pa.us> X-Pg-Spam-Score: -5.1 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Stephen Frost writes: > This particular bike-shedding really doesn't seem to be terribly useful > or sensible, to me. \gx isn't "consistent" or "descriptive", frankly. Why not? To me it reads as "\g with an x option". The "x" refers to the implied "\x", so it's not an arbitrary choice at all. The main problem I see with \G is that it's a dead end. If somebody comes along next year and says "I'd like a variant of \g with some other frammish", what will we do? There are no more case variants to use. In short, really the direction this ought to go in is \g[options] [file] which is perfectly consistent with precedents in psql such as \d. But there isn't any place where we've decided that upper case means a variant of a lower case command. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers