From: | Diana Cionoiu <diana(at)softwaresolutions(dot)ro> |
---|---|
To: | Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Multiple INSERT |
Date: | 2001-05-03 03:20:24 |
Message-ID: | Pine.LNX.4.30.0105030619430.31845-100000@tudor.softwaresolutions.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Randall Perry | 2001-05-03 03:27:28 | Perl Scope problem |
Previous Message | David Scholes | 2001-05-03 02:53:42 | Re: Tuple Max Size on 7.1 |