Susan,
> Thank you all for your assistance. My script ran (almost) straight away
> having followed your advise. Is the psql interface documented anywhere? I
> am used to Oracle and my approach seems a bit "hit-and-miss". Sometimes
> Oracle commands work and sometimes they don't!
You could try buying a book on PostgreSQL, hmmm?
http://techdocs.postgresql.org/techdocs/bookreviews.php
http://www.us.postgresql.org/books/index.html
--
Josh Berkus
Aglio Database Solutions
San Francisco