Date: Thu, 30 Jan 2025 15:35:04 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
Reply-To: Rich Shepard <rshepard@appl-ecosys.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: Using psql's \prompt command [RESOLVED]
In-Reply-To: <6617ae2-214c-28d6-7b67-5071ec2bae57@appl-ecosys.com>
Message-ID: <7cfccedc-42a-1098-70f2-2e3e735786a@appl-ecosys.com>
References: <1dbc1ace-c119-6ed2-d579-561525f3bf0@appl-ecosys.com> <CAKFQuwbBrjF6Hx3zOo1p7=+ui=qeoZiK46-=Ov8JC=5GqvPe2A@mail.gmail.com> <28334f3d-5942-4849-374f-32f2f6a4e9c@appl-ecosys.com> <69ead979-7c20-d246-b52f-3e7af585da3d@appl-ecosys.com>
 <CAKFQuwYk1xeDbna0_6htbvUMptn=TK0rKN=5doOjNPCaQ3zjEA@mail.gmail.com> <CAKFQuwYZs0zuUhNO37ToOUVuAyjsJ91U_Fw=2ouBrHcmQ8UHLg@mail.gmail.com> <6617ae2-214c-28d6-7b67-5071ec2bae57@appl-ecosys.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/7cfccedc-42a-1098-70f2-2e3e735786a%40appl-ecosys.com>
Precedence: bulk

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 before selecting rows:
\prompt 'Enter person_nbr: ' who

select p.person_nbr, p.lname, p.fname, p.direct_phone, p.email, c.contact_date, c.contact_time, c.contact_type, c.notes
from people as p natural inner join contacts as c
where p.person_nbr = (:'who')
order by c.contact_date, c.contact_time;

This works.

Thank you,

Rich