Re: Using psql's \prompt command

2025-01-31 Thread hubert depesz lubaczewski
On Thu, Jan 30, 2025 at 01:47:59PM -0800, Rich Shepard wrote: > # \i person_view.sql > Enter person_nbr: 468 > psql:person_view.sql:9: ERROR: column "store" does not exist > LINE 3: where person_nbr = store >^ > What's the correct syntax for the \prompt? prompt is ok.

Re: Using psql's \prompt command [RESOLVED]

2025-01-30 Thread Rich Shepard
On Thu, 30 Jan 2025, Rich Shepard wrote: Thanks again, David. I didn't know that's the section I need. David/Ron, et al.: Got it (example on page 2126 of the doc): -- Display person_nbr, lname, fname, direct_phone, email from people, contact history from contacts. -- prompt for person_nbr be

Re: Using psql's \prompt command

2025-01-30 Thread Rich Shepard
On Thu, 30 Jan 2025, David G. Johnston wrote: 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

Re: Using psql's \prompt command

2025-01-30 Thread David G. Johnston
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 >> wrote: >> >>> On Thu, 30 Jan 2025, Rich Shepard wrote: >>> >>> > T

Re: Using psql's \prompt command

2025-01-30 Thread David G. Johnston
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 > 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

Re: Using psql's \prompt command

2025-01-30 Thread David G. Johnston
On Thu, Jan 30, 2025 at 3:38 PM Rich Shepard 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 w

Re: Using psql's \prompt command

2025-01-30 Thread Ron Johnson
On Thu, Jan 30, 2025 at 5:28 PM Rich Shepard wrote: > On Thu, 30 Jan 2025, David G. Johnston wrote: > > > Prompt isn’t your issue. Prompt stores the value into a variable. Read > how > > to reference variables in a psql script. > > David, > > Thank you. I'll look into using the \set command. > I

Re: Using psql's \prompt command

2025-01-30 Thread Rich Shepard
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.

Re: Using psql's \prompt command

2025-01-30 Thread Rich Shepard
On Thu, 30 Jan 2025, David G. Johnston wrote: Prompt isn’t your issue. Prompt stores the value into a variable. Read how to reference variables in a psql script. David, Thank you. I'll look into using the \set command. Rich

Using psql's \prompt command

2025-01-30 Thread Rich Shepard
I want to use the \prompt command to get user input for a query. My script fails: -- Display person_nbr, lname, fname, direct_phone, email from people, contact history from contacts. -- prompt for person_nbr before selecting rows: \prompt 'Enter person_nbr: ' store select p.person_nbr, p.lname

Re: Using psql's \prompt command

2025-01-30 Thread David G. Johnston
On Thursday, January 30, 2025, Rich Shepard wrote: > > > What's the correct syntax for the \prompt? > Prompt isn’t your issue. Prompt stores the value into a variable. Read how to reference variables in a psql script. David J.