From: | Torsten Förtsch <tfoertsch123(at)gmail(dot)com> |
---|---|
To: | Wiwwo Staff <wiwwo(at)wiwwo(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Check psql parameter is passed, if not ask for it |
Date: | 2024-08-05 18:55:24 |
Message-ID: | CAKkG4_nWqk1DjxcBGorCBG9+Cdb2YHfSe16vzpEfQkKnkCsRMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
to quote the documentation:
> If an unquoted colon (:) followed by a psql variable name appears within
an argument, it is replaced by the variable's value, as described in SQL
Interpolation below.
> The forms :'variable_name' and :"variable_name" described there work as
well. The :{?variable_name} syntax allows testing whether a variable is
defined. It is
> substituted by TRUE or FALSE. Escaping the colon with a backslash
protects it from substitution.
See https://www.postgresql.org/docs/16/app-psql.html
On Mon, Aug 5, 2024 at 8:46 PM Wiwwo Staff <wiwwo(at)wiwwo(dot)com> wrote:
> Hi!
> I want to check if I pass the parameter "param1" to a sql script
> "delme.sql" like
> ```
> \if ':param1'
> \echo :param1;
> \else
> \prompt 'Param1? ' :param1
> \endif
> select :'param1';
> ```
> if parameter `param1` is not passed, the .sql should ask for it.
>
> If I run something like
> `psql -f delme.sql -v param1=1`
> it works, but if i pass
> `psql -f delme.sql -v param1=meh`
> i receive
> `psql:delme.sql:1: error: unrecognized value ":param1" for "\if
> expression": Boolean expected`
>
> How can I implement that?
> TIA, Wiwwo
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2024-08-06 05:26:25 | Re: Windows installation problem at post-install step |
Previous Message | Wiwwo Staff | 2024-08-05 18:46:06 | Check psql parameter is passed, if not ask for it |