On Thu, Jan 30, 2025 at 3:46 PM David G. Johnston < [email protected]> wrote:
> On Thu, Jan 30, 2025 at 3:44 PM David G. Johnston < > [email protected]> wrote: > >> On Thu, Jan 30, 2025 at 3:38 PM Rich Shepard <[email protected]> >> 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.
