>
> 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. At that point, check out the CSV-array FDW.
Of course, if someone writes a WIP patch which implements the above, we
can evaluate it then.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com