On Apr 3, 2007, at 10:33 AM, A. Kretschmer wrote:
am Tue, dem 03.04.2007, um 7:19:15 -0700 mailte [EMAIL PROTECTED]
folgendes:
I need to do like 1000 inserts periodically from a web app. Is it
better to do
1000 inserts or 1 insert with the all 1000 rows? Is using copy
command faster
tha
am Tue, dem 03.04.2007, um 7:19:15 -0700 mailte [EMAIL PROTECTED] folgendes:
> I need to do like 1000 inserts periodically from a web app. Is it better to do
> 1000 inserts or 1 insert with the all 1000 rows? Is using copy command faster
> than inserts?
You can do the massive Inserts within one
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I am trying to insert multiple values into a table like this.
> INSERT INTO tab_name (col1, col2) VALUES (val1, val2), (val3, val4)
...
> My production server runs in 8.1.5.
...
> What to do?
Upgrade to 8.2. :)
Seriously, you should upgrade
I need to do like 1000 inserts periodically from a web app. Is it better to
do 1000 inserts or 1 insert with the all 1000 rows? Is using copy command
faster than inserts?
thanks
On 4/2/07, Chris <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> Hi
> I am trying to insert multiple values int
[EMAIL PROTECTED] wrote:
Hi
I am trying to insert multiple values into a table like this.
INSERT INTO tab_name (col1, col2) VALUES (val1, val2), (val3, val4)
This works in postgres version 8.2.1
My production server runs in 8.1.5. It gives me
ERROR: syntax error at or near "," at character 35
Hi
I am trying to insert multiple values into a table like this.
INSERT INTO tab_name (col1, col2) VALUES (val1, val2), (val3, val4)
This works in postgres version 8.2.1
My production server runs in 8.1.5. It gives me
ERROR: syntax error at or near "," at character 35
What to do?
thanks
