Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VnQ8i-0006HW-QN for pgsql-sql@arkaria.postgresql.org; Mon, 02 Dec 2013 09:50:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VnQ8i-00071M-Aj for pgsql-sql@arkaria.postgresql.org; Mon, 02 Dec 2013 09:50:04 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VnQ8h-00071A-Je for pgsql-sql@postgresql.org; Mon, 02 Dec 2013 09:50:03 +0000 Received: from mail-wg0-x22e.google.com ([2a00:1450:400c:c00::22e]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VnQ8a-0005ae-Su for pgsql-sql@postgresql.org; Mon, 02 Dec 2013 09:50:02 +0000 Received: by mail-wg0-f46.google.com with SMTP id m15so11442038wgh.13 for ; Mon, 02 Dec 2013 01:49:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:openpgp:content-type:content-transfer-encoding; bh=LdSDO6Kl9GaYGPtnjYbZJXjiGYW08RhleuxELV7tfnQ=; b=Dt7gKJcGLtIeIAyjag2Q1kfOWuYrZfGhHTlSEa8Du18mNpOjNn7zhKctbRK7+ywa1W 0Vc6+y8DPI42Rorn/A3zQFsEKReF8BInHfwBsp1iz4pN5VC+HrkHD4lm09tZZjeszC4Z XtiAAZqEAzwRFMxSgOz5G88+sZ9mvf7pn8hKCIqK7Z2xRIK6x/ZB9qrb+Z/QeRDAIFTa HVdrvzWngS0G/iunmjAHS9LqIzNrd2s1Y8iL5obNnS9O39/oV6m2sqA6Qk8V4GaSPi3t jonG4g7psKnAWXOk5weyJr3Q4xi8iWx5maLG5IgCa/A5I0Tgvsp18yFqpxARlTWPlcQf Bmsg== X-Received: by 10.180.39.140 with SMTP id p12mr17238164wik.12.1385977794599; Mon, 02 Dec 2013 01:49:54 -0800 (PST) Received: from ivan.hi.inet (123.pool85-58-64.dynamic.orange.es. [85.58.64.123]) by mx.google.com with ESMTPSA id g16sm80426403wiw.6.2013.12.02.01.49.52 for (version=TLSv1 cipher=RC4-SHA bits=128/128); Mon, 02 Dec 2013 01:49:53 -0800 (PST) Message-ID: <529C57BF.6050700@gmail.com> Date: Mon, 02 Dec 2013 10:49:51 +0100 From: seikath User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130625 Thunderbird/17.0.7 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: tab delimiter in output References: In-Reply-To: X-Enigmail-Version: 1.5.2 OpenPGP: url= Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) 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 hi Marcin, try that for two tabs : select concat('===[' , E'\t\t',']==='); select '===['|| E'\t\t'||']==='; cheers On 11/25/2013 12:14 PM, Marcin Krawczyk wrote: > Hi, > > 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 ? > > > regards > mk -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql