Additionally, if the Vim option "bomb" is set to "nobomb" it will strip the BOM. This solves my "problem" by permitting editing files in both Vim and pgAdmin3 Query tool and then being able to run the files in psql.
:set nobomb [in Vim]
On Apr 22, 2010, at 12:12 PM, Magnus Hagander wrote:
FYI, psql in PostgreSQL 9.0 will ignore UTF8 BOMs.