"Uwe C. Schroeder" <uwe(at)oss4u(dot)com> writes:
> On Thursday 21 October 2004 12:40 pm, Tom Lane wrote:
>> I don't think that conclusion follows from that premise. In recent
>> pg_dump versions (any that use a column list with COPY, which I think is
>> 7.3 or later) there is no fundamental disadvantage to using COPY; it
>> should be semantically equivalent to INSERT-with-column-list commands.
> The reason is that I made changes to the schema, i.e. changed the ordinal
> position of columns and added some columns. Since the positioning of the
> columns isn't the same anymore a copy will fail.
No, it won't, not if you use a column list.
regards, tom lane