Re: Multiple INSERT - Mailing list pgsql-general

From Diana Cionoiu
Subject Re: Multiple INSERT
Date
Msg-id Pine.LNX.4.30.0105030619430.31845-100000@tudor.softwaresolutions.ro
Whole thread Raw
In response to Multiple INSERT  (Renaud Thonnart <thonnart@amwdb.u-strasbg.fr>)
List 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 by date:

Previous
From: Renaud Thonnart
Date:
Subject: Multiple INSERT
Next
From: tankgirl@worldonline.es
Date:
Subject: Multiple Inheritance