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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to