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

Re: Executing multiple statements in a single query?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: HK <harikrishnan(at)midascomm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Executing multiple statements in a single query?
Date: 2002-09-25 05:06:47
Message-ID: 27742.1032930407@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
HK <harikrishnan(at)midascomm(dot)com> writes:
> 	I am using postgresql from a c application with asyncronous Query 
> processing. Since only 1 query can be executed at a time, i am using  a 
> buffering mechanism to store the other queries generated at that time. Is 
> there any way i can execute all the statements in the buffer with a single 
> query.

You can ship 'em all in a single PQsendQuery string, and wait for the
successive results to come back.  Not sure if that's what you had in
mind...

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: solDate: 2002-09-25 06:16:33
Subject: install problem
Previous:From: HKDate: 2002-09-25 04:44:17
Subject: Executing multiple statements in a single query?

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