Horton

Re: Why doesn't COPY support the HEADER options for tab-separated output?

Merlin Moncure <mmoncure@gmail.com>

View thread View on postgr.es
From: Merlin Moncure <mmoncure@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Joe Van Dyk <joe@tanga.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2013-08-12T22:05:42Z
Lists: pgsql-general 
On Mon, Aug 12, 2013 at 4:21 PM, Bruce Momjian <bruce@momjian.us> wrote:
> On Mon, Aug 12, 2013 at 02:15:25PM -0700, Joe Van Dyk wrote:
>> Mostly just curious, as this is preventing me from using tab-separated output.
>> I'd like there to be a header in my files. I have to use CSVs instead.
>
> [ "this" means the fact that COPY doesn't support the HEADER option. ]
>
> We assume CSV is going to be read into a tool that can use the header
> names;  delimited files don't usually have a use for those headers.

that's a terrible assumption.

merlin