Multiple Inserts

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Multiple Inserts
Date: 2005-07-22 20:49:25
Message-ID: 20050722204925.24107.qmail@web33315.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-07-22 21:09:57 Re: Multiple Inserts
Previous Message K. Hoffrath 2005-07-22 19:11:41 Possible problem when updating a record from two clients at the same time?