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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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