Re: Update Help on PREPARE to mention DEALLOCATE

On Tue, Apr 16, 2024 at 1:27 PM Kirk Wolak <wolakk(at)gmail(dot)com> wrote:

> 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?
>
>
No. That is a syntax excerpt and the prepare command doesn't accept an
optional deallocate keyword at that position.

If we wanted to improve the psql help here we'd have two options:
Add to the description:
prepare a statement for execution (undo this with Deallocate)

or teach our build system to add our "see also" section to the psql help
pages.

The second seems reasonable but non-trivial. The first just seems odd when
reading the website.

There may be a third option but I actually haven't ever explored the psql
help build module.

David J.