Postgres Pro
Downloads
Home   >   mailing lists

Re: Howto use "COPY FROM" with the native API? - Mailing list pgsql-general

From Clemens Eisserer
Subject Re: Howto use "COPY FROM" with the native API?
Date
Msg-id BANLkTik80rVtPDJFyVu4c-toXcv8yYNPKQ@mail.gmail.com
Whole thread Raw
In response to Re: Howto use "COPY FROM" with the native API?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
Hi Pavel,

>> If so, are there some examples how to use "COPY FROM STDIN" with the
>> native C API?
>
> look to source code on \copy implementation in psql
>
> http://doxygen.postgresql.org/bin_2psql_2copy_8c.html
>
> http://www.postgresql.org/docs/8.1/static/libpq-copy.html

Thanks for the pointer, I also found some very old docs with a few examples.

Works perfectly, inserting every ~128kb of text data postgresql
produces less than 2% load for 2000 inserts/s :)ä

Thanks, Clemens

pgsql-general by date:

Previous
From: "Henry C."
Date:
Subject: Trying out replication: cp cannot stat log file during recovery
Next
From: Mike Orr
Date:
Subject: Re: pg_restore