Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tddBI-008ajc-Pd
	for pgsql-general@arkaria.postgresql.org; Thu, 30 Jan 2025 22:38:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tddBH-00DeV5-LH
	for pgsql-general@arkaria.postgresql.org; Thu, 30 Jan 2025 22:38:39 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1tddBH-00DeUx-AO
	for pgsql-general@lists.postgresql.org; Thu, 30 Jan 2025 22:38:39 +0000
Received: from mail.appl-ecosys.com ([50.126.108.78])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <rshepard@appl-ecosys.com>)
	id 1tddBE-002PjQ-0f
	for pgsql-general@postgresql.org;
	Thu, 30 Jan 2025 22:38:38 +0000
Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1])
	by mail.appl-ecosys.com (Postfix) with ESMTP id 307EC2A43CF
	for <pgsql-general@postgresql.org>; Thu, 30 Jan 2025 14:38:34 -0800 (PST)
Date: Thu, 30 Jan 2025 14:38:34 -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
In-Reply-To: <28334f3d-5942-4849-374f-32f2f6a4e9c@appl-ecosys.com>
Message-ID: <69ead979-7c20-d246-b52f-3e7af585da3d@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>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/69ead979-7c20-d246-b52f-3e7af585da3d%40appl-ecosys.com>
Precedence: bulk

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.

Regards,

Rich