On Mar 26, 2011, at 5:31 PM, Trent George wrote:
> Is it (or would it) be possible to allow some type of equivalent of
> BATCHSIZE as used in mssql BULK INSERT command
> This would group and commit this number of records during the import,
> while it is still running
> One could in theory use a value of =1, =1000 or leave the default (whole batch)
There is nothing built-in for what you describe, but you could accomplish the desired result on your end. e.g. split the import into batches of 1000 (or whatever) and issue individual COPY commands for each one. This could all be wrapped into a sh/perl/whatever script to make it reusable, configurable, add error handling, etc.
Jon