How to concatenate psql variables? How can I concatenate two psql (PostgreSQL client) variables? I want to generate an absolute path by concatenating a directory path variable and a filename variable.

I've tried this:

\set path '/tmp/'
\set file 'foo'
\echo :path:file


But psql puts a space between the path and the file, and outputs:

/tmp/ foo
\set path '/tmp/'
\set file 'foo'
\set pf :path:file \echo :pf
/tmp/foo


Why does this work? I quote the manual here:


  \set [ name [ value [ ... ] ] ]
  
  Sets the internal variable name to value or, if more than one value is given, to the concatenation of all of them. [...]


Emphasis mine.