Search Postgresql Archives

Check psql parameter is passed, if not ask for it

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux