Re: tab delimiter in output
| От | Marcin Krawczyk |
|---|---|
| Тема | Re: tab delimiter in output |
| Дата | |
| Msg-id | CABnqL32fqsmkY9smiSkcP2mLsHaT0LP=ORfnrN5wrgtqzVdNHw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: tab delimiter in output (Thomas Kellerer <spam_eater@gmx.net>) |
| Список | pgsql-sql |
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@gmx.net>
Marcin Krawczyk, 25.11.2013 12:14:Which SQL tool do you use?> 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 ?
>
Maybe your SQL client simply doesn't display the tab character?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
В списке pgsql-sql по дате отправления: