I seem to be blundering a lot today! I thought I was replying to the entire
list, didn't realize I replied to one person :-)
Nothing was wrong with my script, I assumed that since it was generated by
pgAdmin that I could run it inside pgAdmin. It works perfectly when I run it
using psql. It is very much like SQL Server's osql command line tool. Thanks
to everyone that helped ...
So I've learnt three valuable lessons:
1. It's better to execute scripts using the command line tool 'psql'.
2. Make sure I'm replying to the list and not to an individual.
3. Do not post HTML messages!!! :-))
Thanks again everyone.
Rommel Edwards
Software Developer,
Barbados, Caribbean.