From: Sean Davis <sdavis2@mail.nih.gov>
Reply-To: sdavis2@mail.nih.gov
Organization: NIH/NCI
To: pgsql-interfaces@postgresql.org
Subject: Re: ECPG and COPY FROM STDIN
Date: Mon, 20 Nov 2006 06:42:23 -0500
User-Agent: KMail/1.9.1
Cc: Niels Laakmann <nielsson@grillen23.de>
References: <20061120111317.9889D77A3B@mail.toxisch.net>
In-Reply-To: <20061120111317.9889D77A3B@mail.toxisch.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200611200642.23872.sdavis2@mail.nih.gov>

On Monday 20 November 2006 06:12, Niels Laakmann wrote:
> 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 ?

How about here:

http://www.postgresql.org/docs/8.1/interactive/libpq-copy.html

Sean