Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yurdx-0004wn-Tv for pgsql-general@arkaria.postgresql.org; Wed, 20 May 2015 00:13:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yurdx-0008Hu-99 for pgsql-general@arkaria.postgresql.org; Wed, 20 May 2015 00:13:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yurdv-0008ET-6V; Wed, 20 May 2015 00:13:51 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Yurdr-0004uc-Px; Wed, 20 May 2015 00:13:49 +0000 Received: from [192.168.1.3] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 63E37281; Tue, 19 May 2015 17:13:46 -0700 (PDT) Received: from [192.168.1.3] ([67.168.169.165] helo=[192.168.1.3]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 19 May 2015 17:13:45 -0700 Message-ID: <555BD1C6.4000301@commandprompt.com> Date: Tue, 19 May 2015 17:13:58 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: Ravi Krishna , pgsql-sql@postgresql.org CC: pgsql-general@postgresql.org Subject: Re: Does PG support bulk operation in embedded C References: <8A634A74EF65401FBE09169A72984EBB@RaviLaptop> In-Reply-To: <8A634A74EF65401FBE09169A72984EBB@RaviLaptop> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-80826-01121 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-general@postgresql.org X-Assp-Original-Subject: Re: [GENERAL] Does PG support bulk operation in embedded C X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general