Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cY90C-0001hB-J2 for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 10:16:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cY90C-0005Dg-07 for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2017 10:16:00 +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 1cY8ym-0003XA-34 for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 10:14:32 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cY8yi-00067q-6q for pgsql-hackers@postgresql.org; Mon, 30 Jan 2017 10:14:30 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 3vBlcK1Wf8z3F13; Mon, 30 Jan 2017 11:14:25 +0100 (CET) Date: Mon, 30 Jan 2017 11:14:25 +0100 From: Christoph Berg To: Daniel Verite Cc: PostgreSQL Hackers Subject: Re: One-shot expanded output in psql using \G Message-ID: <20170130101424.fo4knpn4blaohazk@msg.df7cb.de> Mail-Followup-To: Christoph Berg , Daniel Verite , PostgreSQL Hackers References: <20170127132737.6skslelaf4txs6iw@msg.credativ.de> <74e7fd23-f5a9-488d-a8c4-1e0da674b27c@manitou-mail.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <74e7fd23-f5a9-488d-a8c4-1e0da674b27c@manitou-mail.org> User-Agent: NeoMutt/20161126 (1.7.1) 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 Re: Daniel Verite 2017-01-28 <74e7fd23-f5a9-488d-a8c4-1e0da674b27c@manitou-mail.org> > > Mysql's CLI client is using \G for this purpose, and adding the very > > same functionality to psql fits nicely into the set of existing > > backslash commands: \g sends the query buffer, \G will do exactly the > > same as \g (including parameters), but forces expanded output just for > > this query. > > +1 for the functionality but should we choose to ignore the comparison > to mysql, I'd suggest \gx for the name. IMHO \G is a tad easier to type than \gx, though the difference isn't huge, so I would be fine with either. But do we really want to choose something different just because MySQL is using it? \G will be much easier to explain to existing users (both people coming from MySQL to PostgreSQL, and PostgreSQL users doing a detour into foreign territory), and it would be one difference less to have to care about when typing on the CLIs. +1 on \G. Christoph -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers