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.