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.
On Apr 22, 2010, at 11:50 AM, Dave Page wrote:
> On Thu, Apr 22, 2010 at 10:41 AM, John Gage <jsmgage@numericable.fr>
> wrote:
>> This may be germane:
>>
>> Filename: trunk/pgadmin3/src/ui/pgadmin3.lng
>> Revision 2954 - (view) (download) - [select for diffs]
>> Modified Sun Nov 30 20:13:28 2003 GMT (6 years, 4 months ago) by
>> andreas
>> File length: 1301 byte(s)
>> Diff to previous 2840
>> adding UTF-8 BOM
>
> No, that's a BOM being added to a multi-language source file.
> pgAdmin's Unicode support has always written an appropriate BOM to
> Unicode files. See
> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/pgadmin/utils/utffile.cpp
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise Postgres Company
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general