Re: [GENERAL] COPY with default values won't work?
Charles Tassell <ctassell@isn.net>
From: Charles Tassell <ctassell@isn.net>
To: Vadim Mikheev <vadim@krs.ru>
Cc: pgsql-general@postgreSQL.org
Date: 1999-03-24T05:48:22Z
Lists: pgsql-general
@#$#!! 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) BTW: Thanks for the quick response. I send the mail, answer some messages, and get a response. Quicker than a Microsoft $0.95/min help line. :-) At 01:24 AM 3/24/99, you wrote: >This is standard behaviour. DEFAULT is for INSERT only, >when attribute is not specified in INSERT' target list. > >Vadim