Josh Berkus <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers