Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 96E899FB467 for ; Fri, 8 Jun 2007 05:44:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 73942-05 for ; Fri, 8 Jun 2007 05:44:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by postgresql.org (Postfix) with ESMTP id 6225F9FB46F for ; Fri, 8 Jun 2007 05:44:26 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so457650ana for ; Fri, 08 Jun 2007 01:44:23 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:disposition-notification-to:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=eUvyCTeQR0AZ/TRbOZ6CRdC4vyZo5uN+8n8qwat/XZCie1LAqC4hXRAkisRRtg83/S2LIPyDLggQBzpxwMOyWPD89tiIaQMbUvVOArVSdHDNpAbXfy0m0+ldahQ59+DkpFrWdGypDi8JRPT0atXnCiUoc5erWCSQu2JYy25Ac6c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:disposition-notification-to:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=WtTvmMdlD419CFWFjgeGRTIw/0xA3M3U6jepp2QKIjEhHTv3u4v5PK+e9qRtcUsQu9k+m+Tk+EC2NCOnwMAJfSYPBp+nI7JdjjGPynNldg8tWfum9dVN+gwjIG49gAJwRohlsYQf0ShgS6vvs8Tyqe6vwrPWEcpcnfQ8j52g60Q= Received: by 10.114.123.1 with SMTP id v1mr2346474wac.1181292263365; Fri, 08 Jun 2007 01:44:23 -0700 (PDT) Received: from ?222.71.196.226? ( [222.71.196.226]) by mx.google.com with ESMTP id v35sm208444wah.2007.06.08.01.44.21 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 08 Jun 2007 01:44:22 -0700 (PDT) Message-ID: <466916DA.2080903@gmail.com> Date: Fri, 08 Jun 2007 16:44:10 +0800 From: =?gb18030?Q?=C0=EE=D1=E5_Ian_Li?= User-Agent: Mozilla-Thunderbird 2.0.0.0 (X11/20070601) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: [newbie] How to do "batch insert"? Content-Type: text/plain; charset=GB18030; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/1 X-Sequence-Number: 3803 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: I wonder while doing so, will it commit in each LOOP or just ONCE? Thanks and Regards, Ian