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 по дате отправления:

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: Re: [GENERAL] COPY with default values won't work?
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [GENERAL] COPY with default values won't work?