BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM - Mailing list pgsql-bugs

From Peter Jukel
Subject BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM
Date
Msg-id 201003310441.o2V4fEMm048826@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5398
Logged by:          Peter Jukel
Email address:      pjukel@triplehash.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

pgsql-bugs by date:

Previous
From: "Ing . Marcos Luís Ortíz Valmaseda"
Date:
Subject: ...
Next
From: "Teodor Buchner"
Date:
Subject: BUG #5400: Columns count mismatch in RULE with subquery