David Fetter <da...@fetter.org> writes: > OK, new proposal: > COPY FROM (Thanks, Andrew! Must not post while asleep...) should have > an option which requires that HEADER be enabled and mandates that the > column names in the header match the columns coming in.
> Has someone got a better name for this option than > KEEP_HEADER_COLUMN_NAMES? Well, if it's just checking that the list matches, then maybe CHECK_HEADER would do. In your original proposal, I was rather wondering what should happen if the incoming file didn't have the same set of columns called out in the COPY command's column list. (That is, while *rearranging* the columns might be thought non-astonishing, I'm less convinced about a copy operation that inserts or defaults columns differently from what the command said should happen.) If we're just checking for a match, that question goes away. 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