Re: tab delimiter in output

This might be the case. I'm using pgAdmin but I can't find anything in it's
configuration.

2013/11/25 Thomas Kellerer <spam_eater(at)gmx(dot)net>

> 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?
>
>
>
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>