Re: psql: Add command to use extended query protocol - Mailing list pgsql-hackers

I got thinking about this, and while things may be fine as-is, I would like to hear some opinions as to whether this behavior is correct:

String literals can include spaces

[16:51:35 EST] corey=# select $1, $2 \bind 'abc def' gee \g
 ?column? | ?column?
----------+----------
 abc def  | gee
(1 row)


String literal includes spaces, but also includes quotes:

Time: 0.363 ms
[16:51:44 EST] corey=# select $1, $2 \bind "abc def" gee \g
 ?column?  | ?column?
-----------+----------
 "abc def" | gee
(1 row)

Semi-colon does not terminate an EQP statement, ';' is seen as a parameter:

[16:51:47 EST] corey=# select $1, $2 \bind "abc def" gee ;
corey-# \g
ERROR:  bind message supplies 3 parameters, but prepared statement "" requires 2


Confirming that slash-commands must be unquoted

[16:52:23 EST] corey=# select $1, $2 \bind "abc def" '\\g' \g
 ?column?  | ?column?
-----------+----------
 "abc def" | \g
(1 row)

[16:59:00 EST] corey=# select $1, $2 \bind "abc def" '\watch' \g
 ?column?  | ?column?
-----------+----------
 "abc def" | watch
(1 row)

Confirming that any slash command terminates the bind list, but ';' does not

[16:59:54 EST] corey=# select $1, $2 \bind "abc def" gee \watch 5
Mon 21 Nov 2022 05:00:07 PM EST (every 5s)

 ?column?  | ?column?
-----------+----------
 "abc def" | gee
(1 row)

Time: 0.422 ms
Mon 21 Nov 2022 05:00:12 PM EST (every 5s)

 ?column?  | ?column?
-----------+----------
 "abc def" | gee
(1 row)

Is this all working as expected?