"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
> But there will be new syntax for COPY, that allows missing trailing columns.
> I hope.
>>
>> Why?
> Well, good question. For one for backwards compatibility.
It's an undocumented feature. How many people are likely to be using it?
> I guess I would prefer COPY syntax that allows you to specify columns
> as has been previously discussed.
Yes, that's on the to-do list as well. But no matter what the expected
set of columns is, COPY ought to complain if a line is missing some
fields.
regards, tom lane