Re: [GENERAL] COPY with default values won't work?

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