Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 110669F9C35 for ; Mon, 20 Nov 2006 07:34:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 02261-06 for ; Mon, 20 Nov 2006 07:34:39 -0400 (AST) X-Greylist: delayed 00:21:36.789073 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D320E9FA217 for ; Mon, 20 Nov 2006 07:34:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.toxisch.net (mail.toxisch.net [88.198.180.59]) by svr4.postgresql.org (Postfix) with ESMTP id 7A52E5AF8C6 for ; Mon, 20 Nov 2006 11:12:57 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.toxisch.net (Postfix) with ESMTP id E331977A78 for ; Mon, 20 Nov 2006 12:13:27 +0100 (CET) Received: from mail.toxisch.net ([127.0.0.1]) by localhost (toxisch.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 08687-08 for ; Mon, 20 Nov 2006 12:13:17 +0100 (CET) Received: from mavis (port-83-236-24-251.dynamic.qsc.de [83.236.24.251]) by mail.toxisch.net (Postfix) with ESMTP id 9889D77A3B for ; Mon, 20 Nov 2006 12:13:17 +0100 (CET) Date: Mon, 20 Nov 2006 12:12:41 +0100 From: Niels Laakmann To: pgsql-interfaces@postgresql.org Subject: ECPG and COPY FROM STDIN X-Mailer: Sylpheed-Claws 2.4.0 (GTK+ 2.8.18; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Message-Id: <20061120111317.9889D77A3B@mail.toxisch.net> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mail.toxisch.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200611/1 X-Sequence-Number: 6316 Hey List! I have to do a Benchmark-Test in C (ECPG) with and without network. After reading the Performance and COPY Documentation (not correctly), I wanted to Copy a File over the Network by using "COPY FROM 'filename'". After some curious Problems I knew why. Now I read some about "COPY FROM STDIN. But I didn't find an Example. Can someone please give me an Example for that ? Or: Is there another command to insert many tuples from a Client to a Server in an adequate time ? Niels