View Single Post

   
  #2 (permalink)  
Old 04-11-2008, 07:07 AM
Andrew Dunstan
 
Posts: n/a
Default Re: COPY FROM with CSV header

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote