Re: Multiple INSERT

Поиск
Список
Период
Сортировка
От Diana Cionoiu
Тема Re: Multiple INSERT
Дата
Msg-id Pine.LNX.4.30.0105030619430.31845-100000@tudor.softwaresolutions.ro
обсуждение исходный текст
Ответ на Multiple INSERT  (Renaud Thonnart <thonnart@amwdb.u-strasbg.fr>)
Список pgsql-general
> Could someone explain me what is the advantage of that technique ?
> Because if I have to build a temporary table before being able to
> perform multiple INSERT, I work 2 times more, isn't it ?
> Or perhaps does it exist a way to perform multiple insert without build
> a temporary table; something like :
> INSERT INTO table
> VALUES(...,...,...),
> VALUES(...,...,...);
> I really need your advice!

SELECT * INTO is your friend.

> Thank you all,
> Sincerelly, Renaud THONNART

Diana Cionoiu


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

Предыдущее
От: Renaud Thonnart
Дата:
Сообщение: Multiple INSERT
Следующее
От: tankgirl@worldonline.es
Дата:
Сообщение: Multiple Inheritance