I just wanted to confirm that the COPY command always stores data in the
table in the order in which it appears in the import file.
I.e., if the import file is sorted ahead of time, am I correct in
assuming that the COPY command can have the same effect as CLUSTER'ing
(or as creating a new table as an ordered select on the loaded table)?
(Indexes would of course be applied after the data load.)
Thanks,
Kevin Murphy