Josh Berkus <j...@agliodbs.com> writes: > Question on COPY, though: there's reasons why people would want COPY to > dump in either physical or logical order. If you're doing COPY to > create CSV files for output, then you want the columns in logical order. > If you're doing COPY for pg_dump, then you want them in physical order > for faster dump/reload. So we're almost certainly going to need to have > an option for COPY.
This is complete nonsense, Josh, or at least it is until you can provide some solid evidence to believe that column ordering would make any noticeable performance difference in COPY. I know of no reason to believe that the existing user-defined-column-ordering option makes any difference. 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