Re: [SQL] Does PG support bulk operation in embedded C

["Ravi Krishna" <srkrishna@xxxxxxx>]

Not sure whether I am understanding this. I checked embedded C and did not find any section which describes what I have asked, that is the ability to do multiple inserts, or updates or deletes in one sql call. For example, if my application does the following

BEGIN TRANSACTION
   INSERT INTO TABLE_A
   UPDATE TABLE_B
   INSERT INTO TABLE_C

COMMIT TRANSACTION

DB2 provides to combine the three sql operations into an array and make a call to DB2 which executes the array (that is all 3 sqls as one single call).

I am looking for something similar in PG.

thanks

 

Sent: Tuesday, May 19, 2015 at 8:13 PM
From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
To: "Ravi Krishna" <srkrishna@xxxxxxx>, pgsql-sql@xxxxxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [SQL] Does PG support bulk operation in embedded C

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.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.

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-sql mailing list (pgsql-sql@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql