The following bug has been logged online:
Bug reference: 5398
Logged by: Peter Jukel
Email address: pjukel(at)triplehash(dot)com
PostgreSQL version: 8.4
Operating system: Mac OSX 10.5.8
Description: psql gives syntax error on .sql files with UTF-8 BOM
Details:
The psql command gives syntax errors when fed .sql files that are saved with
encoding "UTF-8" and contain a BOM (byte order marker). When the same file
is saved using the encoding "UTF-8, no BOM", the syntax error is removed.
The irony is that the query tool supplied with PostGres (PGAdmin) saves with
the BOM. So it would appear to me that any script written in this tool would
display a syntax error.
Regards
Peter