Date: Fri, 31 Jan 2025 14:12:07 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Using psql's \prompt command
Message-ID: <Z5zMJ7cFdv2LyEbl@depesz.com>
Reply-To: depesz@depesz.com
References: <1dbc1ace-c119-6ed2-d579-561525f3bf0@appl-ecosys.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <1dbc1ace-c119-6ed2-d579-561525f3bf0@appl-ecosys.com>
Archived-At: <https://www.postgresql.org/message-id/Z5zMJ7cFdv2LyEbl%40depesz.com>
Precedence: bulk

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.
but you can't just throw variable name in the query and assume it will
get substituted.
the proper syntax is :store, or (better) :'store'
and again: not in the *\prompt* line - in the place where you use it.

You might want to read
https://www.depesz.com/2023/05/28/variables-in-psql-how-to-use-them/

Best regards,

depesz