Charles Tassell wrote:
>
> @#$#!! Any way to make COPY use default, or shove a lot of data in with a
> single INSERT query? According to older messages in the mailing list, it
> is *possible*, but I can't get it to work.
>
> My problem is that I might be using this to put a few thousand entries in
> the db every night, and when I last attempted this using a few thousand
> insert statements, it was awfully slow (on the order of taking HOURS)
@#$#!!
-:)
Use BEGIN/END to insert a few thousand rowes in SINGLE transaction.
Vadim
