Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYFRZ-0003JP-5q for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 17:08:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYFRY-0002n9-KK for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 17:08:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYFRX-0002n2-Lm for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 17:08:39 +0000 Received: from 173-164-140-181-sfba.hfc.comcastbusiness.net ([173.164.140.181] helo=fetter.org) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYFRU-0005Ng-S0 for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 17:08:38 +0000 Received: by fetter.org (Postfix, from userid 1000) id 2FE1BE023A; Mon, 30 Jan 2017 09:08:36 -0800 (PST) Date: Mon, 30 Jan 2017 09:08:36 -0800 From: David Fetter To: "David G. Johnston" Cc: Tom Lane , Stephen Frost , Pavel Stehule , Christoph Berg , Daniel Verite , PostgreSQL Hackers Subject: Re: One-shot expanded output in psql using \G Message-ID: <20170130170836.GC24826@fetter.org> 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> <24326.1485789276@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.7.1 (2016-10-04) X-Pg-Spam-Score: -0.9 (/) 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 On Mon, Jan 30, 2017 at 08:22:40AM -0700, David G. Johnston wrote: > On Mon, Jan 30, 2017 at 8:14 AM, Tom Lane wrote: > > 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. > > > > +1 +1 from me, too, for what it's worth. If we're expanding the meanings of \g, let's do it with at least some eye to future expansions. Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers