Re: Howto use "COPY FROM" with the native API?

From: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Howto use "COPY FROM" with the native API?
Date: 2011-04-12 20:37:07
Message-ID: BANLkTik80rVtPDJFyVu4c-toXcv8yYNPKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Orr 2011-04-12 21:09:57 Re: pg_restore
Previous Message Henry C. 2011-04-12 19:45:12 Trying out replication: cp cannot stat log file during recovery