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: No such file or directory leif=> \i ${IMPORTDIR}/test.sql ${IMPORTDIR}/test.sql: No such file or directory -- Leif Biberg Kristensen http://solumslekt.org/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org