Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cX6zw-0001NG-KL for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Jan 2017 13:55:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cX6zw-00067q-7K for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Jan 2017 13:55:28 +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 1cX6yV-0003ij-4A for pgsql-hackers@postgresql.org; Fri, 27 Jan 2017 13:53:59 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cX6yQ-0002tl-Nk for pgsql-hackers@postgresql.org; Fri, 27 Jan 2017 13:53:57 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 3DB0E5F794; Fri, 27 Jan 2017 08:52:54 -0500 (EST) Date: Fri, 27 Jan 2017 08:52:54 -0500 From: Stephen Frost To: Christoph Berg , PostgreSQL Hackers Subject: Re: One-shot expanded output in psql using \G Message-ID: <20170127135254.GE9812@tamriel.snowman.net> References: <20170127132737.6skslelaf4txs6iw@msg.credativ.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="CZWcADy7OmVqBrCQ" Content-Disposition: inline In-Reply-To: <20170127132737.6skslelaf4txs6iw@msg.credativ.de> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 08:52:00 up 202 days, 15:16, 7 users, load average: 0.04, 0.16, 0.17 User-Agent: Mutt/1.5.21 (2010-09-15) 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 --CZWcADy7OmVqBrCQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Christoph, * Christoph Berg (christoph.berg@credativ.de) wrote: > The same idea was discussed back in 2008. Back then the outcome was > that "\x auto" was implemented, but I still think that \G is a useful > feature to have on its own, and several people in the thread seem to > have agreed back then. +1 for my part. I often run a query and then realize that I really wanted \x output. Thanks! Stephen --CZWcADy7OmVqBrCQ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYi1C1AAoJEO1sijiDR2RVxMsP/3kp/Jnj6QmVxSrWBNukDfHM tSP6IoHjVi9lIrrlBT7Xj8+mt/geTZ2L2SRP8e5RG0nypH6FJ0BHqXYlACgZ+trH R6hRLzMw6GfbLUpCvEZDXcuJkOkvqr8sWin0oqG3WCR+mI7ztF3qjzmqzCcRMy1+ i2N+E7kMyjEG17AYK6ZOFAXNTlgBnVwnp2exkq0WuVYJXvRSWO+j0tB4RI1b7JVu Tt3wTtdRQO2daFeq/q82txCPiHwZU6mTB58lEHOdqW4F1iKBh8iCw9WGXszlCGdf xSIU9rrEbLUcan4tr1AomRMFySCxodiA2c78xsGS13MF0TPmV+y5x+uIeMI5NGXm WeXouMn44LHGTBE7YAxuX0n+Xf6u0CFsJL580YX/B8foMWvvhQNEV5qOn/6AIOHa LysnF6loIrsS+tLzCluom89fyAa3X8yVgakD/uVQbSYEmxFRM/4F/XIABjYY9CuT 4mMYEZvkFLVzudXQduleu8/OJnymZIT4bFnFLeigqTpihxeOeL6ToZpsivvSRSZh E9Wxpbn8YLn8c21LYEOhkLAM+1JYD2Bf/2XL/0ZPX10Um+/efoYIa7FTIVOUuqYe YWRWNQUmtlAsyzIw62wssFNhfnqBijFzAgI4nqKi8xdIyLd9i8QsPIS/9lsYqpQB T3W83Ozatu6VoFTauc03 =0veo -----END PGP SIGNATURE----- --CZWcADy7OmVqBrCQ--