1. 5

  2. 3

    i think there’s an additional problem (although i haven’t looked at this carefully; this is from a friend'’s comments). as far as i know, the copy command requires all columns. so you need to include any surrogate keys. which can make things much more complicated when you have the possibility of multiple loads in parallel.