Multiple statements in one prepare
How can multiple SQL statements be included in one prepare command? The goal is to reduce chatter between the client and server by submitting an atomic tranasaction set. My interface is libpq.
"Robert Turnbull" <rturnbull@strategicmind.com> writes:
How can multiple SQL statements be included in one prepare command?
They can't. Consider using a plpgsql function, instead.
regards, tom lane
On 15-Apr-04, at 9:26 AM, Robert Turnbull wrote:
How can multiple SQL statements be included in one prepare command?
The goal is to reduce chatter between the client and server by
submitting an atomic tranasaction set.
You can submit multiple PREPARE commands in one query string (separated
by semi-colons), so the difference in FE/BE traffic should be
negligible.
-Neil