| 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: | 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
| 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? |