COPY FROM with CSV header

Поиск
Список
Период
Сортировка
Искать

COPY FROM with CSV header

От:
"Jim C. Nasby" <jnasby@pervasive.com>
Дата:
Instead of ignoring the first line of a COPY FROM ... WITH CSV HEADER,
what about allowing the first line to be used as a list of field names?
This means you wouldn't have to include field order in the COPY command
if the names matched field names in the table.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: COPY FROM with CSV header

От:
Andrew Dunstan <andrew@dunslane.net>
Дата:
Jim C. Nasby wrote:

>Instead of ignoring the first line of a COPY FROM ... WITH CSV HEADER,
>what about allowing the first line to be used as a list of field names?
>This means you wouldn't have to include field order in the COPY command
>if the names matched field names in the table.
>  
>
It was debated ... could be dangerous, and you'd need extra syntax, 
since we couldn't make it the default.

cheers

andrew
FAQ