Re: psql: Add command to use extended query protocol

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Michael Paquier <michael@paquier.xyz>

Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2022-10-28T13:35:55Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Add command to use extended query protocol
- 5b66de3433e2 16.0 landed

Michael Paquier <michael@paquier.xyz> writes:
> On Fri, Oct 28, 2022 at 08:52:51AM +0200, Peter Eisentraut wrote:
>> Two, for testing the extended query protocol from psql.  For example, for
>> the dynamic result sets patch [1], I have several ad-hoc libpq test programs
>> lying around, which would be cumbersome to integrate into the patch.  With
>> psql support like proposed here, it would be very easy to integrate a few
>> equivalent tests.

> +1.  As far as I recall, we now have only ECPG to rely on when it
> comes to coverage of the extended query protocol, but even that has
> its limits.  (Haven't looked at the patch)

pgbench can be used too, but we lack any infrastructure for using it
in the regression tests.  Something in psql could be a lot more
helpful.  (I've not studied the patch either.)

			regards, tom lane