Postgres Pro
Downloads
Home   >   mailing lists

Re: Using psql's \prompt command - Mailing list pgsql-general

From Ron Johnson
Subject Re: Using psql's \prompt command
Date
Msg-id CANzqJaAWHhkaOq5LzMUTPq38zg6D3=PGP42YjDEGdO11kRnOrQ@mail.gmail.com
Whole thread Raw
In response to Re: Using psql's \prompt command  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
On Thu, Jan 30, 2025 at 5:28 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Thu, 30 Jan 2025, David G. Johnston wrote:

> Prompt isn’t your issue. Prompt stores the value into a variable. Read how
> to reference variables in a psql script.

David,

Thank you. I'll look into using the \set command.

Instead of \set (which can be tricky and unintuitive), consider the dialog command with "psql --set=NAME=VALUE".

 
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Using psql's \prompt command
Next
From: "David G. Johnston"
Date:
Subject: Re: Using psql's \prompt command