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: 20101228050805.5FFC219CFB3@mail.netbsd.org (view raw or flat)
Thread:
Lists: pgsql-novice
hi,

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.

YAMAMOTO Takashi

Responses

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-2014 The PostgreSQL Global Development Group