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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
