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 ) id 1tdcQP-008WYZ-2l for pgsql-general@arkaria.postgresql.org; Thu, 30 Jan 2025 21:50:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tdcQO-00DQM3-7n for pgsql-general@arkaria.postgresql.org; Thu, 30 Jan 2025 21:50:12 +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 ) id 1tdcQN-00DQLv-R5 for pgsql-general@lists.postgresql.org; Thu, 30 Jan 2025 21:50:11 +0000 Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tdcQK-002PIS-2Z for pgsql-general@postgresql.org; Thu, 30 Jan 2025 21:50:11 +0000 Received: by mail-oa1-x31.google.com with SMTP id 586e51a60fabf-29ff8053384so655749fac.3 for ; Thu, 30 Jan 2025 13:50:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738273807; x=1738878607; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LYIpvLVhrM1nRazEWMwstmcliZPpTmYrCPDMjMT0JoM=; b=R27Vre7Z/rJlRDJ9aTPm5/8tsb8DidL6hZm9mCCR0VjbYnB8Pnm/TdkQSBKyeGKLPw UzK1hFMFHUO+MIipZH7c35Vpu8TiBaF0keS1OjY09TME71MH2noph1ecYX0eXXxiQPSZ A7whArYN+IfkSnOheODpKisUZzRHm8JNipg4/X1gcR4Oi8Svx16bnjwThPP9t3kevXUo YNP8j4ubR0uQieMJy0zylnzETbD05ha2QuXSYiFFe8+uaaLZu2JHqnmnueDGjp4XRAOT J6JSrYl5s4egXHhIngSbRVslsB597IcvJsfyw34EyNerJZgMXeDo/ZhIt1IWdTp8GrzV up7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738273807; x=1738878607; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=LYIpvLVhrM1nRazEWMwstmcliZPpTmYrCPDMjMT0JoM=; b=vmEtTALbZ26G9o5mWXYn6AmCXf2WJSQngVAfql2QL8sf5aJ2UyZ0wcQjOmfRTrJHR2 ZixCz7QtszoEOaApdApjhQsJlp5VqC22H/7HfvoigecfBdCp7RLteU0DxHt4BE3vftcX EA3pXaGdtXahCR04saI+LiNPP7LFzRvy+1Ps66uN365vh4pw9D12k0lmA2nQiXBl98UG kALGO8Yb87OKb9+DCP865FMwFrgFl1sWK8VTmvPxyRE3ia/WzrrSJyqSF2uiLGjehXEY +enNFlu2O78t6INP2MtRGwkapfvGAw6MjR9Py/G/2GPbPTfl/eViXKgoJqHd7XjKDcWh rj/w== X-Gm-Message-State: AOJu0YzowdG6CZ7ZOfUUQFq8+CnbSLdIbrkJt9nVY8xvsqzbFsrpQOVZ dNQ3p/mZ8IMt00HuMVLWf9nAG/tymJMvj+oiEjCQEfFizTvOEMfD+1BIGcoMYBVnqqg4pKIT9DB LWbW/LMZIwscw8HbTDVcvn/MhDEo= X-Gm-Gg: ASbGncvInqcUITCzaXwUn2MS32E9TZYk+7ZQe5aCCdc+VUfVtpBKGOy58v0ev86RqD2 +1XC4E0QpeR27DTya+0sR9bBtWAFa9YMZVqGPIaFsMlBQbDUx1NLtRzPutzgeHDQjz1mQJ9c= X-Google-Smtp-Source: AGHT+IG5JOoaSzIDbqXUA+X7ss9piyV982fsbjHqc5CCqYLMNlKSHhg0OK3hgBdruvIFm/mE93hp6dlvKirjL3LG+Wg= X-Received: by 2002:a05:6871:d30b:b0:29e:32e7:5f17 with SMTP id 586e51a60fabf-2b32f2d8098mr5141316fac.28.1738273807045; Thu, 30 Jan 2025 13:50:07 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:49a:b0:577:9519:f64a with HTTP; Thu, 30 Jan 2025 13:50:06 -0800 (PST) In-Reply-To: <1dbc1ace-c119-6ed2-d579-561525f3bf0@appl-ecosys.com> References: <1dbc1ace-c119-6ed2-d579-561525f3bf0@appl-ecosys.com> From: "David G. Johnston" Date: Thu, 30 Jan 2025 14:50:06 -0700 X-Gm-Features: AWEUYZk-EWbLFNh_zPMLExLjt3hEp39SS5fklqfLzDLatplzSPWzQnsKXJm1MFA Message-ID: Subject: Re: Using psql's \prompt command To: Rich Shepard Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ca9e6b062cf368c4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ca9e6b062cf368c4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, January 30, 2025, Rich Shepard wrote: > > > What's the correct syntax for the \prompt? > Prompt isn=E2=80=99t your issue. Prompt stores the value into a variable. = Read how to reference variables in a psql script. David J. --000000000000ca9e6b062cf368c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, January 30, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:

What's the correct syntax for the \prompt?

Prompt isn=E2=80=99t your issue.=C2=A0 Pro= mpt stores the value into a variable.=C2=A0 Read how to reference variables= in a psql script.

David J.

--000000000000ca9e6b062cf368c4--