Re: User input to queries [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: User input to queries [RESOLVED]
Date
Msg-id alpine.LNX.2.20.2012090954000.10199@salmo.appl-ecosys.com
Whole thread Raw
In response to User input to queries  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Wed, 9 Dec 2020, Laurenz Albe wrote:

> You probably need the \prompt psql command:
> \prompt 'What is "p.lname"' p_lname
> \prompt 'What is "p.fname"' p_fname
> SELECT ... WHERE p.lname = :p_lname AND p.fname = :p_fname;

Laurenz,

Ah! I have not before encountered that command. Yes, this will do the job
and I'll make it a point to look at _all_ available psql commands.

Thanks very much.

Stay well,

Rich



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: User input to queries
Next
From: Rich Shepard
Date:
Subject: Re: User input to queries