Re: tab delimiter in output

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?