Postgres Pro
Downloads
Home   >   mailing lists

Re: How to insert bulk data with libpq in C? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: How to insert bulk data with libpq in C?
Date
Msg-id 80ed60d54a29cb8bf3058dc0b9f5d44cf244378c.camel@cybertec.at
Whole thread Raw
In response to How to insert bulk data with libpq in C?  ("a" <372660931@qq.com>)
Responses Re: How to insert bulk data with libpq in C?  (Chris Mair <chris@1006.org>)
List pgsql-general
Tree view 
a wrote:
> May I ask the proper (fast) way of inserting bulk data and if possible, an example would be very appreciated.
> 
> Please note that the data I would like to insert contains arrays (float8[]).
> 
> By the way, my environment is Windows 10, PostgreSQL 11 and compiling with Visual Studio 2017.

That would be COPY:
https://www.postgresql.org/docs/current/sql-copy.html

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: IF NOT EXIST
Next
From: Chris Mair
Date:
Subject: Re: How to insert bulk data with libpq in C?