psql and tab-delimited output
От | Abelard Hoffman |
---|---|
Тема | psql and tab-delimited output |
Дата | |
Msg-id | CACEJHMgrpHXWvYrcCu_WtKZEyeZJ3dzO5GddsL4Y377d7wzbRw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: psql and tab-delimited output
Re: psql and tab-delimited output Re: psql and tab-delimited output |
Список | pgsql-general |
Hi.
Traditionally, to generate a TSV report, I've simply invoked psql with:
--no-align --field-separator '\t' --pset footer=off
That works in most cases, except when your column values contain tabs themselves.
I know that COPY() will escape tabs (as \t), and we can use that from psql with the \copy command, but that does not include a header row of the column names.
So, my question is, what's the simplest way to generate tab-escaped TSV-formatted reports with the first line containing the list of column names?
I also considered handling the escaping myself within the SELECT, and then sticking with the first approach above.
Suggestions?
Thanks.
В списке pgsql-general по дате отправления: