tab delimiter in output

From: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: tab delimiter in output
Date: 2013-11-25 11:14:43
Message-ID: CABnqL31Db_0XBY_yNzDhZTJE1e7FBCSDU3QQwLX1q=ZHU1UE0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-11-25 11:26:35 Re: tab delimiter in output
Previous Message Adrian Klaver 2013-11-24 17:06:58 Re: Importing MySql dumped db into pgadmin