Re: [GENERAL] Accessing environment variables from psql (SOLVED)

On Sunday 10 April 2005 03:39, Andreas Seltenreich wrote: > You can concatenate values using \set. So using > > \set importfile :importdir /test.sql > \i :importfile > > you won't have to mess with $PWD. Thanks for the tip, Andreas. But I have about a dozen sql files in the import direct

Re: [GENERAL] Accessing environment variables from psql (SOLVED)

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

Re: [GENERAL] Accessing environment variables from psql (SOLVED)

On Saturday 09 April 2005 13:59, Leif B. Kristensen wrote: > Is there a way to access environment variables from psql? After scrutinizing the psql documentation at , I found that this actually works: leif=> \set importdir `echo $IMPORTDIR

[GENERAL] Accessing environment variables from psql

Is there a way to access environment variables from psql? I can't find any documentation on how to do this: leif=> \! echo $IMPORTDIR /home/leif/slekta/import/scripts leif=> \i $IMPORTDIR/test.sql $IMPORTDIR/test.sql: No such file or directory leif=> \i $(IMPORTDIR)/test.sql $(IMPORTDIR)/test.sql