Обсуждение: BUG #15385: Copy from using CSV ignores the header

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

BUG #15385: Copy from using CSV ignores the header

От
PG Bug reporting form
Дата:
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, but it's totally ludicrous, 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

Re: BUG #15385: Copy from using CSV ignores the header

От
"David G. Johnston"
Дата:
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.