[newbie] How to do "batch insert"?

李彦 Ian Li <[email protected]>
Newsgroups gmane.comp.db.postgresql.php
Message-ID <[email protected]>
Hi all.
In the scene I want to insert all elements of an array in to a 
table, how can I do to commit them as a whole?
currently I do like this:

<?php
$result = pg_prepare($dbconn, "ins_acl", 'INSERT INTO 
acls(oid,uid,gid,mod) VALUES($1,$2,$3,$4)');
for($i=0;$i<count($p["acls"]);$i++){
	pg_execute($dbconn, "ins_lgs",$p["acls"][i]);
}
?>

I wonder while doing so, will it commit in each LOOP or just ONCE?

Thanks and Regards,

Ian

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.