Re: Accessing environment variables from psql (SOLVED) - Mailing list pgsql-general

Leif B. Kristensen writes:

> So, the problem is solved, sort of. It may also be prudent to save the
> old pwd and return there when the work is done:
>
> leif=> \set olddir `echo $PWD`
> leif=> \set importdir `echo $IMPORTDIR`
> leif=> \cd :importdir
> leif=> \i test.sql
> leif=> \cd :olddir

You can concatenate values using \set. So using

    \set importfile :importdir /test.sql
    \i :importfile

you won't have to mess with $PWD.

regards,
Andreas