Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VkuZH-0005tT-FW for pgsql-sql@arkaria.postgresql.org; Mon, 25 Nov 2013 11:43:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VkuZG-0005K9-QT for pgsql-sql@arkaria.postgresql.org; Mon, 25 Nov 2013 11:43:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VkuZF-0005K2-RN for pgsql-sql@postgresql.org; Mon, 25 Nov 2013 11:43:05 +0000 Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VkuZ9-0004hI-VU for pgsql-sql@postgresql.org; Mon, 25 Nov 2013 11:43:05 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VkuZ6-0006fj-QK for pgsql-sql@postgresql.org; Mon, 25 Nov 2013 12:42:56 +0100 Received: from 217.110.94.67 ([217.110.94.67]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 25 Nov 2013 12:42:56 +0100 Received: from spam_eater by 217.110.94.67 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 25 Nov 2013 12:42:56 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: tab delimiter in output Date: Mon, 25 Nov 2013 12:42:46 +0100 Lines: 16 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 217.110.94.67 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 In-Reply-To: X-Pg-Spam-Score: 1.3 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Marcin Krawczyk, 25.11.2013 12:14: > I need to return concatenated columns separated by tab character and I can't get it to work. Here's what I tried: > > SELECT concat('aa', '\t', 'bb'); > SELECT concat('aa', CHR(9), 'bb'); > SELECT 'aa' || CHR(9) || 'bb'; > SELECT 'aa' || '\t' || 'bb'; > > I get "aabb" instead of "aa bb" in all cases. Is this a configuration issue ? > Which SQL tool do you use? Maybe your SQL client simply doesn't display the tab character? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql