Re: COPY FROM with CSV header - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: COPY FROM with CSV header
Date
Msg-id 434594E8.8040205@dunslane.net
Whole thread Raw
In response to COPY FROM with CSV header  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: prefix btree implementation
Next
From: "Kevin Grittner"
Date:
Subject: slower merge join on sorted data chosen over nested loop