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'
But psql puts a space between the path and the file, and outputs: