Susan,
> Following reading through all the documentation it is not clear to me how
> to run a script file containing a number of SQL commands. Presumably I do
> this through the psql interface but how do I tell it to run a script?
In PSQL:
\i filename
From the command line, or from cron:
Postgres_dir/bin/psql -U username database < scriptfile
Easy as cake!
--
Josh Berkus
Aglio Database Solutions
San Francisco