Check psql parameter is passed, if not ask for it

From: Wiwwo Staff <wiwwo(at)wiwwo(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Check psql parameter is passed, if not ask for it
Date: 2024-08-05 18:46:06
Message-ID: CAD1W9HXadWboboY+f4JVvMy8=hx-9POPskBoQq1T34AGofMPQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2024-08-05 18:55:24 Re: Check psql parameter is passed, if not ask for it
Previous Message Dominique Devienne 2024-08-05 15:09:20 Re: UPDATE-FROM and INNER-JOIN