Re: User input to queries [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: User input to queries [RESOLVED]
Date: 2020-12-09 17:55:37
Message-ID: alpine.LNX.2.20.2012090954000.10199@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2020-12-09 17:56:59 Re: User input to queries
Previous Message Rich Shepard 2020-12-09 17:53:41 Re: User input to queries