Re: [GENERAL] Does PG support bulk operation in embedded C - Mailing list pgsql-sql

From Ravi Krishna
Subject Re: [GENERAL] Does PG support bulk operation in embedded C
Date
Msg-id trinity-cd0fd5f4-144c-4472-a699-0adb04055119-1432135431375@3capp-mailcom-lxa10
Whole thread Raw
In response to Re: [GENERAL] Does PG support bulk operation in embedded C  (john <johnf@jfcomputer.com>)
Responses Re: [GENERAL] Does PG support bulk operation in embedded C  (Steve Midgley <steve.midgley@learningtapestry.com>)
List pgsql-sql
> Anyway, taking the function name 'bulk' into account - I think you want 
> find the best way to to insert a large number of row/records.
> 
> Review the 'copy' command to populate a database:
> http://www.postgresql.org/docs/9.1/static/populate.html  - read 
> carefully as it will increase performance in a dramatic way.

I am aware of the copy command, but we are talking about application inserting rows from a C++ task
with values coming in variables. Does COPY handle that? COPY looks more closer to sqlloader of Oracle.

DB2 Bulkcopy API is damn good. We have applications inserting tens of rows in one single call.



pgsql-sql by date:

Previous
From: john
Date:
Subject: Re: [GENERAL] Does PG support bulk operation in embedded C
Next
From: Steve Midgley
Date:
Subject: Re: [GENERAL] Does PG support bulk operation in embedded C