Multiple Inserts - Mailing list pgsql-novice

From
Subject Multiple Inserts
Date
Msg-id 20050722204925.24107.qmail@web33315.mail.mud.yahoo.com
Whole thread Raw
In response to Re: duplicate key violates unique constraint. (repost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Multiple Inserts
List pgsql-novice
before going to well again, i just want to say a big
"thank you" to all the folks who generously give their
time and help guys like me learn more about
postgresql.  i've learned a lot and saved a ton on
aspirin!

i need to insert multiple serial numbers at a time
(eg, 100).  my current idea is to allow the user to
enter a beginning serial number, an ending serial
number and then use php to iterate through the numbers
and insert them (i'm thinking multiple inserts (get
value -> insert, get 2nd value -> insert, get 3rd
value, insert, etc...) unless someone can give me an
idea how to collect the data then do one big insert).

is this the best way to proceed or does pgsql offer
some kind of functionality that assists in this type
of process.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: "Oren Mazor"
Date:
Subject: Re: dead tuples
Next
From: Michael Fuhr
Date:
Subject: Re: Multiple Inserts