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: