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.