On 7/29/22 04:05, Gianni Ceccarelli wrote:
> If you can use bash, or set up some redirections from whatever you're
> using to execute ``psql``, you can do::
>
> $ psql somedb --set num=42 <<<'select :num'
> Timing is on.
> Expanded display is used automatically.
> Line style is unicode.
> Border style is 2.
> ┌──────────┐
> │ ?column? │
> ├──────────┤
> │ 42 │
> └──────────┘
> (1 row)
>
> Time: 0.517 ms
>
> or (more classically)::
>
> echo 'select :num' | psql somedb --set num=42
Since my process uses the same variable in multiple bash statements, I
decided to use a bash environment variable.
--
Angular momentum makes the world go 'round.
