Re: Why doesn't COPY support the HEADER options for tab-separated output?
Jeff Janes <jeff.janes@gmail.com>
From: Jeff Janes <jeff.janes@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:17:00Z
Lists: pgsql-general
On Mon, Aug 12, 2013 at 2: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. There have been a few cases where I wanted this, too. I can see why implementing it is less important than having it for CSV, but is there a reason to consider this harmful for TEXT format? I.e. if someone submitted a patch, would it be rejected? Cheers, Jeff