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.