Josh Berkus <josh@agliodbs.com> writes:
>>
>> 4) MAP_HEADER ('column 1'-> 'col_1', 'Date' -> 'input_date' ...)
>>
>> to cover the case when column names do not match.
> Personally, I think that's going way beyond what we want to do with
> COPY.
I agree --- if you know that much about the incoming data, you might as
well just specify the correct column list in the COPY command. This
would only have use if you know somebody used weird column names, but
not the order they put the columns in; which seems like a thin use-case.
The three options Josh enumerated seem reasonably sane to me.
regards, tom lane