Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group