multiple inserts

Поиск
Список
Период
Сортировка
От Oren Mazor
Тема multiple inserts
Дата
Msg-id op.ssinv7h7v14azh@localhost.localdomain
обсуждение исходный текст
Ответы Re: multiple inserts  (Michael Fuhr <mike@fuhr.org>)
Re: [despammed] multiple inserts  (Andreas Kretschmer <akretschmer@despammed.com>)
Re: multiple inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
hi all,

I'm wondering if it is at all possible to do a mass insert into a table
using only a single query?

Something along the lines of:

insert into mytable values (val1), (val2), (val3)

rather than doing three discrete insert into statements.

this seems like something that should be there, but a week's worth of
googling hasnt turned anything up.

thanks
Oren

--
    A voice crackles in Calvin's radio:
    "Enemy fighters at two o'clock!"
    "Roger. What should I do until then?"

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Trigger and Trigger function.
Следующее
От: John DeSoi
Дата:
Сообщение: Re: Trigger and Trigger function.