Re: COPY with column headings - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: COPY with column headings
Date
Msg-id 4120D13F.2050503@dunslane.net
Whole thread Raw
In response to COPY with column headings  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: COPY with column headings  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers

Bruce Momjian wrote:

>Someone just asked about a COPY capability to supply the column headings
>as the first line of the copy statement.  Do we want to support
>something like that?  Does anyone else want such functionality?
>
>  
>

I had it in mind all along as a possible option for CSV mode, but given 
the heat that was generated by the minimal implementation we did, I 
thought I'd let it rest.

I certainly think it's worth considering, although I see Tom has 
objected :-) . Say we have an option called FIRSTLINELABELS, then on 
copy out it would write the headings on the first line, and on copy in 
it could just ignore the first line (so it could work symmetrically).

cheers

andrew


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: COPY with column headings
Next
From: Bruce Momjian
Date:
Subject: Re: COPY with column headings