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-02 09:03:44
Message-ID: 3AEFCD70.A93965A5@amwdb.u-strasbg.fr
Views: Raw Message | Whole Thread | 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 mkb 2001-05-02 10:23:32 RE: Ideal hardware configuration for pgsql
Previous Message Karel Zak 2001-05-02 08:35:16 Re: chr() command in PG7.03?