Does PG support bulk operation in embedded C - Mailing list pgsql-general

From Ravi Krishna
Subject Does PG support bulk operation in embedded C
Date
Msg-id 8A634A74EF65401FBE09169A72984EBB@RaviLaptop
Whole thread Raw
Responses Re: Does PG support bulk operation in embedded C  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Does PG support bulk operation in embedded C  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
To explain pls refer to this for DB2

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html

Essentially in one single sql call, we can do
-- Add new rows
-- Update a set of rows where each row is identified by a bookmark
-- Delete a set of rows where each row is identified by a bookmark
-- Fetch a set of rows where each row is identified by a bookmark

This gives tremendous performance benefits as the network round trip is
avoided for each sql.

I am looking for an equivalent of this in PG and C language.

Thanks.



pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Documentation bug?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Does PG support bulk operation in embedded C