Re: COPY with column headings

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: COPY with column headings
Дата
Msg-id 200408161528.i7GFS5u12966@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: COPY with column headings  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: COPY with column headings  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Andrew Dunstan wrote:
> 
> 
> 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).

Yes, that is what I was thinking.  Is this a TODO?  Sure it can be
misused but most copy options can be similarly misused.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: COPY with column headings
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY with column headings