Alan Millington <admilling...@yahoo.co.uk> writes:
> I am running Postgres 8.4.1 on Windows XP Professional Service Pack 3. My
> database is UTF8. I use psql -f to load files containing DDL and DML
> commands. I discovered a long time ago that psql does not like UTF8 files: it
> complains about the byte order mark on the first line. Up to now I have
> worked round that by making sure that the files were saved as what Microsoft
> calls "ANSI". However, that option is not available if I want to insert data
> which includes non-ASCII characters.
FWIW, psql 9.0 and later will ignore an initial BOM if the client
encoding is UTF8.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
