X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 461B3D1ECAD for ; Fri, 2 Apr 2004 16:42:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86759-02 for ; Fri, 2 Apr 2004 12:42:37 -0400 (AST) Received: from web41601.mail.yahoo.com (web41601.mail.yahoo.com [66.218.93.101]) by svr1.postgresql.org (Postfix) with SMTP id 930EBD1EC97 for ; Fri, 2 Apr 2004 12:42:31 -0400 (AST) Message-ID: <20040402164234.67207.qmail@web41601.mail.yahoo.com> Received: from [208.21.221.245] by web41601.mail.yahoo.com via HTTP; Fri, 02 Apr 2004 08:42:34 PST Date: Fri, 2 Apr 2004 08:42:34 -0800 (PST) From: Shelby Cain Subject: Bulk updates/inserts To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/4 X-Sequence-Number: 4825 Is it currently possible to perform bulk updates/inserts via host arrays using ecpg? If so, would someone mind showing me an example of the proper syntax as I can't seem to come up with something that the ecpg preprocessor likes. On a side note, if ecpg doesn't support bulk inserts/updates are there any plans for adding such support? Is there anyway programmatically to get close to the same speed for inserts/updates as say the COPY command? Regards, Shelby Cain __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/