> 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?