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 directory, one for each table. So it's actually easier to do a
cd there and run the import, than to concatenate the pathname to every
single file name.
However, running an install script from within psql may be the wrong
approach. I might as well define and populate the database from a shell
script.
--
Leif Biberg Kristensen
http://solumslekt.org/