Sending psql variable into shell

Question

I'd like to send variable in psql into shell to do some tricky things with it there and use the result in psql again. See:

\set ENVIR `echo :HOST | cut -f2 -d-`
\echo :ENVIR

However, the psql variable seems to be not interpolating in backticks as I would expect: shell's echo :HOST gives just :HOST. Help, please.

Dmitri · Accepted Answer · 2015-04-02 16:13:40Z

1

You need to use \setenv to export the psql variable to the shell:

\set HOST 'the-host-name'
\setenv HOST :HOST
\set ENVIR `echo $HOST | cut -f2 -d-`
\echo :ENVIR

produces:

host

Of course, your example can be done with postgres string functions, with no need for shelling out.

answered Apr 2, 2015 at 16:13

Dmitri

9,1675 gold badges39 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1