Skip site navigation (1) Skip section navigation (2)

batching commands with libpq

From: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi)
To: pgsql-novice(at)postgresql(dot)org
Subject: batching commands with libpq
Date: 2010-12-28 05:08:05
Message-ID: (view raw or whole thread)
Lists: pgsql-novice

is there any way to send multiple commands together (ideally in a single
network packet), and then wait for their results, using libpq?  i want to
save extra round-trips.  while postgresql's fe-be on-wire protocol seems
to allow it (is it right?), i couldn't find a way with libpq.

PQsendQuery(conn, "select timeofday();select timeofday();select timeofday();");
seems to work, but i want to use extended protocol.



pgsql-novice by date

Next:From: AarniDate: 2010-12-28 13:51:35
Subject: Re: Send parameters using Shell script to PostgreSQL
Previous:From: wolfangDate: 2010-12-27 19:41:48
Subject: Send parameters using Shell script to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group