psql and tab-delimited output

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.