Re: [GENERAL] COPY with default values won't work?
| От | Charles Tassell |
|---|---|
| Тема | Re: [GENERAL] COPY with default values won't work? |
| Дата | |
| Msg-id | 4.1.19990324014400.00b105d0@mailer.isn.net обсуждение исходный текст |
| Ответ на | Re: [GENERAL] COPY with default values won't work? (Vadim Mikheev <vadim@krs.ru>) |
| Ответы |
Re: [GENERAL] COPY with default values won't work?
Re: [GENERAL] COPY with default values won't work? |
| Список | 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
В списке pgsql-general по дате отправления: