Does PG support bulk operation in embedded C

From: "Ravi Krishna" <srkrishna(at)gmx(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Does PG support bulk operation in embedded C
Date: 2015-05-19 23:47:12
Message-ID: 8A634A74EF65401FBE09169A72984EBB@RaviLaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2015-05-20 00:13:58 Re: Does PG support bulk operation in embedded C
Previous Message Thomas Kellerer 2015-05-19 12:14:16 Re: Documentation bug?

Browse pgsql-sql by date

  From Date Subject
Next Message Joshua D. Drake 2015-05-20 00:13:58 Re: Does PG support bulk operation in embedded C
Previous Message Tim Dudgeon 2015-05-19 09:48:40 Re: generating json without nulls