agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Joshua D. Drake <jd@commandprompt.com>
To: Ravi Krishna <srkrishna@gmx.com>
To: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Does PG support bulk operation in embedded C
Date: Tue, 19 May 2015 17:13:58 -0700
Message-ID: <555BD1C6.4000301@commandprompt.com> (raw)
In-Reply-To: <8A634A74EF65401FBE09169A72984EBB@RaviLaptop>
References: <8A634A74EF65401FBE09169A72984EBB@RaviLaptop>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>


On 05/19/2015 04:47 PM, Ravi Krishna wrote:
>
> 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...
>
>
> 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.

For embedded C, I believe you are looking for:

http://www.postgresql.org/docs/9.4/static/ecpg.html


>
> Thanks.
>
>
>


-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

view thread (9+ messages)  latest in thread

Message-ID: <555BD1C6.4000301@commandprompt.com>
Permalink:  ../555BD1C6.4000301@commandprompt.com/
Also on:    postgresql.org/message-id/555BD1C6.4000301@commandprompt.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jd@commandprompt.com, srkrishna@gmx.com, pgsql-general@postgresql.org
  Subject: Re: Does PG support bulk operation in embedded C
  In-Reply-To: <555BD1C6.4000301@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox