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 <http://www.postgresql.org/docs/8.0/static/app-psql.html>, I found that this actually works: leif=> \set importdir `echo $IMPORTDIR` leif=> \echo :importdir /home/leif/slekta/import/scripts This doesn't: leif=> \i :importdir/test.sql \i: extra argument "/test.sql" ignored But this does: leif=> \cd :importdir leif=> \i test.sql 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 -- Leif Biberg Kristensen http://solumslekt.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
