On Thu, Jan 30, 2025 at 3:46 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Jan 30, 2025 at 3:44 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Thu, Jan 30, 2025 at 3:38 PM Rich Shepard <rshep...@appl-ecosys.com> >> wrote: >> >>> On Thu, 30 Jan 2025, Rich Shepard wrote: >>> >>> > Thank you. I'll look into using the \set command. >>> >>> My web searches find many examples of using the \set command, but none >>> getting user input with \prompt. >>> >>> Please point me to a reference where I can learn how to get the user >>> input >>> string into the script. >>> >> >> That is what \prompt is for. You have the correct meta-command, you were >> capturing user input just fine. Read about how to use variables in queries >> for the part you are missing. >> > > Specifically the section of the psql docs titled: > > SQL Interpolation > > Or: Advanced Features - Variables David J.
