Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZwtYZ-0002F2-2A for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Nov 2015 15:12:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZwtYY-0002Tq-Kn for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Nov 2015 15:12:58 +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) (envelope-from ) id 1ZwtXE-0000yq-Sw for pgsql-hackers@postgresql.org; Thu, 12 Nov 2015 15:11:36 +0000 Received: from fr1.2ndquadrant.fr ([2001:41d0:2:127c::1]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZwtXA-0003st-OK for pgsql-hackers@postgresql.org; Thu, 12 Nov 2015 15:11:36 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by fr1.2ndquadrant.fr (Postfix) with ESMTP id A18D27D8C6; Thu, 12 Nov 2015 16:11:29 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at fr1.2ndquadrant.fr Received: from fr1.2ndquadrant.fr ([127.0.0.1]) by localhost (fr1.2ndquadrant.fr [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ki_0vJB0u26o; Thu, 12 Nov 2015 16:11:28 +0100 (CET) Received: from [192.168.0.3] (ath91-3-88-167-161-184.fbx.proxad.net [88.167.161.184]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: charles) by fr1.2ndquadrant.fr (Postfix) with ESMTPSA id 730867D88E; Thu, 12 Nov 2015 16:11:28 +0100 (CET) Subject: Re: psql: add \pset true/false To: Marko Tiikkaja , PostgreSQL hackers References: <56308F56.8060908@joh.to> From: Vik Fearing Message-ID: <5644AC1F.8080005@2ndquadrant.fr> Date: Thu, 12 Nov 2015 16:11:27 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: <56308F56.8060908@joh.to> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.3 (--) 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 10/28/2015 10:03 AM, Marko Tiikkaja wrote: > Hello hello, > > Since the default t/f output for booleans is not very user friendly, > attached is a patch which enables you to do for example the following: > > =# \pset true TRUE > Boolean TRUE display is "TRUE". > =# \pset false FALSE > Boolean FALSE display is "FALSE". > =# select true, false; > bool | bool > ------+------- > TRUE | FALSE > (1 row) I think the battle is already lost, but I'm casting my vote in favor of this patch anyway. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers