Stephen Bacon writes:
> Now I know the COPY command is much faster because it doesn't update the
> indexes after every row insert, but building that and passing it via
> jdbc seems iffy (or C, PHP, etc. for that matter).
I think someone was working on a COPY implementation for jdbc, but I don't
think it's there yet.
> Can anyone give a recommended technique for this sort of process?
Feed a few thousand INSERTs to addBatch(), then call executeBatch(). That
seems to be the fastest way to import data, at this time.
