BUG #15385: Copy from using CSV ignores the header

On Fri, Sep 14, 2018 at 9:49 AM, PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 15385
Logged by: David Betterton
Email address: dab1961uk@gmail.com
PostgreSQL version: 9.5.14
Operating system: Linux
Description:

This is stated in the documentation,

Which makes it "not a bug", -general would be the appropriate list to use
here.

but it's totally ludicrous,

not its not

it means
that every csv has to conform to the order of the database columns, or the
caller has to explicitly set the column order - which is in the CSV file

And if one doesn't rely upon column position and instead wants to key off
of names then you have to ensure the table and csv files names are in
agreement.

History suggests the cost/benefit of change in this area is pretty low.

David J.