Please notice this exchange:
16:20:02 devuser@nctest= # \h deallocate
Command: DEALLOCATE
Description: deallocate a prepared statement
Syntax:
DEALLOCATE [ PREPARE ] { name | ALL }
URL: https://www.postgresql.org/docs/16/sql-deallocate.html
16:20:11 devuser@nctest= # \h PREPARE
Command: PREPARE
Description: prepare a statement for execution
Syntax:
PREPARE name [ ( data_type [, ...] ) ] AS statement
URL: https://www.postgresql.org/docs/16/sql-prepare.html
Notice. The DEALLOCATE shows [ PREPARE ]
Which is great because the two commands go together.
Unfortunately it's asymmetry is painful. Because I ALWAYS remember PREPARE.
It's DEALLOCATE I always struggle to remember.
Could we make the PREPARE line read
PREPARE [ DEALLOCATE ] ...?
So it's more consistent, and the user using a PREPARE gets a clue to
DEALLOCATE?
Thanks!
