Multiple INSERT

From: Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Multiple INSERT
Date: 2001-05-03 08:35:17
Message-ID: 3AF11845.68D0E243@amwdb.u-strasbg.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone!
I have readen in the doc of PostgreSQL that we can insert several tuples

in a table at one time.
But it is said that the tuples to insert must be the result of a SELECT.

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!
Thank you all,
Sincerelly, Renaud THONNART

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thor Ralle 2001-05-03 08:50:40 Running PostgresSQL in memory
Previous Message Sergey E. Volkov 2001-05-03 08:29:57 Re: Ideal hardware configuration for pgsql