On Thu, Apr 22, 2010 at 12:02, John Gage <jsmg...@numericable.fr> wrote: > I think I should clarify my original "problem" and what I see as the > difficulty in general. > > I saved a UTF-8 file with the pgAdmin Query tool, which added the BOM to the > beginning of the file during the save. > > I then attempted to run the file using psql with the \i meta command. > > I got a syntax error pointing at the very beginning of the file which turned > out to be on account of the BOM. > > In other words, files saved with pgAdmin3 Query tool cannot then be run as > files of SQL commands by psql. > > The two applications are incompatible at that level.
FYI, psql in PostgreSQL 9.0 will ignore UTF8 BOMs. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
