Home > mailing lists

tab delimiter in output - Mailing list pgsql-sql

From	Marcin Krawczyk
Subject	tab delimiter in output
Date	November 25, 2013 14:15:11
Msg-id	CABnqL31Db_0XBY_yNzDhZTJE1e7FBCSDU3QQwLX1q=ZHU1UE0A@mail.gmail.com Whole thread Raw
Responses	Re: tab delimiter in output (Ian Lawrence Barwick <barwick@gmail.com>) Re: tab delimiter in output (Thomas Kellerer <spam_eater@gmx.net>) Re: tab delimiter in output (seikath <seikath@gmail.com>)
List	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

From: Adrian Klaver
Date: 24 November 2013, 20:07:06
Subject: Re: Importing MySql dumped db into pgadmin

From: Ian Lawrence Barwick
Date: 25 November 2013, 14:26:41
Subject: Re: tab delimiter in output