Neil Conway wrote:

Kevin Murphy wrote:

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.


This is not the case -- depending on the content of the FSM, the newly added rows might be distributed throughout the table.

How about for a freshly created, empty table -- I should have qualified my original statement.

Thanks,
Kevin


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to