[newbie] How to do "batch insert"? - Mailing list pgsql-php

From 李彦 Ian Li
Subject [newbie] How to do "batch insert"?
Date
Msg-id 466916DA.2080903@gmail.com
Whole thread Raw
Responses Re: [newbie] How to do "batch insert"?  (Mihail Mihailov <Mihail.Mihailov@uta.fi>)
List pgsql-php
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

pgsql-php by date:

Previous
From: Chris
Date:
Subject: Re: Get Extension in Bytea Type
Next
From: Mihail Mihailov
Date:
Subject: Re: [newbie] How to do "batch insert"?